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]

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]

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]

You should update the guide to reflect that.
I think that the domain name "example.com" implies that...