remove password

[Lefu]

dear friends,

 

I am using xp and installed mysql 5, I want to know how do I remove password. I want to log in to mysql db with out entering password on my local machine.

 

thanks a lot

[PHP Monkeh]

Update your username to have a blank password field.

 

Log in to mysql using your current username & password in command prompt:

 

mysql -u USERNAME -p PASSWORD

 

Select the mysql database

 

use mysql;

 

Then update the user that you want to have without a username (I'd advise against setting the root user to have no password)

 

UPDATE `user` SET `Password` = '' WHERE `User` = 'YOUR_USERNAME';

 

 

[Lefu]

Thanx it worked like hot knife on butter.