MySQL on perfect setup CentOS 5.2

[spuppy]

When I enter the command

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

I get the error:

mysqladmin: connect to server at 'server1.example.com' failed
error: 'Host 'server1.example.com' is not allowed to connect to this MySQL server'

I don't think this will stop my install, but I would like to make sure everything is working perfectly

Thanks!

[bolero]

localhost? Then simply do not use -h. You try to connect from non-localhost this way and there's likely an ACL to allow only root@localhost.

[falko]

IS server1.example.com your hostnme?
What are the outputs of

hostname -f

and

netstat -tap | grep mysql

?

[spuppy]

I was just following the instructions directly. They tell you to set your hostname to server1.example.com, so that's what I did. I guess we're supposed to set the hostname again later once everything is installed... Once I do that, I'll see if MySQL can connect.

[createch]

.... do you mean you also use "yourrootsqlpassword" instead of using the actual MySQL password in your system too ?

[falko]

Originally Posted by spuppy

They tell you to set your hostname to server1.example.com, so that's what I did.

You should replace server1.example.com with your own hostname.

[spuppy]

Originally Posted by falko

You should replace server1.example.com with your own hostname.

You should update the guide to reflect that. With guides like this, the reader will always follow it to the letter. If you say 'enter this information' people will do just that. So you need to make sure that if the user is entering their own information, that they know to do so.

[till]

This is already described at the biginning of the howto

In this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100 and the gateway 192.168.0.1. These settings might differ for you, so you have to replace them where appropriate.

[falko]

Originally Posted by spuppy

You should update the guide to reflect that.

I think that the domain name "example.com" implies that...