Re: Alternative to "mysql -u root"?

[Umesh Shastry]

Hi!!

Its for everyone.. for localhost you need to replace % with localhost or 127.0.0.1..

Grant statment should be ..

mysql>GRANT ALL ON *.* TO ''@'localhost';

Check out the user table(this should be in mysql database)..

update the host column to 'localhost'... for the user ''..

Your query should be...

mysql>UPDATE user SET Host='localhost' where user='';
mysql>FLUSH PRIVILEGES;

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221