Hello.
>>error: 'Host 'localhost.domain.ca' is not allowed to connect to this If MySQL thinks that you're connecting from from 'localhost.domain.ca' you should have an entry in grant tables for this host. If you're unable to connect to MySQL as root, reset permissions an add user 'root'@'localhost.domain.ca'. See: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html http://dev.mysql.com/doc/refman/5.0/en/grant.html Peter wrote: > --- Peter <[EMAIL PROTECTED]> wrote: > > >>This has happened to me so many times I am finally going to ask. Why in >>the hell when I follow the directions given immediately after installing >>do I get an error? >> >>Here is what the thing says after installing (and I quote): >> >>" >>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! >>To do so, start the server, then issue the following commands: >>/usr/local/bin/mysqladmin -u root password 'new-password' >>/usr/local/bin/mysqladmin -u root -h blah.domain.ca password >>'new-password' >>" >> >>Ok, Ok, I'll do it! >> >># mysqladmin -u root -h blah.domain.ca password 'password' >>This worked. > > > The above line should read: > > # mysqladmin -u root password 'password' > > >># mysqladmin: connect to server at 'blah.domain.ca' failed >>error: 'Host 'localhost.domain.ca' is not allowed to connect to this >>MySQL >>server' > > > The error was produced after trying this: > > # mysqladmin -u root -h blah.domain.ca password 'password' > > >>Huh?????? >> >>I'm using package 4.0.24 on OpenBSD 3.8. Grrrrrr. > > > > > > > > __________________________________________________________ > Find your next car at http://autos.yahoo.ca > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
