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 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
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...