Problem with Ubuntu 6.06 LTS Perfect Guide

[lwizardl]

Everytime I follow any of the guides (Ubutnu 6.06 LTS, Ubuntu 6.10, or Centos 4.4) I get an error at the exact same place

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

the first part goes in just fine but when I add the -h server in front of the user I get this error evertime

unable to connect to server server.tld (will post exact error in few mins I'm sure I'll get it again retrying the install)
*edited to include error

mysqladmin -u root password **removed**
mysqladmin -h **removed** -u root password **removed**
mysqladmin: connect to server at '**removed**' failed
error: 'Host '**removed**' is not allowed to connect to this MySQL server'

[falko]

This happens because you don't have server1.example.com in the Host column of the user table in the mysql database.
You can use phpMyAdmin later on to change the hostname and restart MySQL. Afterwards, the command will work.

BTW, did you use the forum's search function? Because this topic has been covered a zillion times here...

[lwizardl]

thanks for the quick answer. I did browse but I didn't see anything that matched.

James

[till]

Originally Posted by lwizardl

thanks for the quick answer. I did browse but I didn't see anything that matched.

James

Just make sure that there is no record for user root without password, then everything is fine.