mysql passwd

[karl]

how do can i remove mysql password ?

[MAGnUm]

To change the root password, you will need to load up a command window, go to C:\wampp\mysql\bin (where C is your drive where MySQL is installed) and run the program mysql. This gives you a Command Line interface to the database.

Once you open it, you can run the following
use mysql
(tells the program to use the mysql database which contains all of the information)
select host, user, password from user \g
(the \g tells mysql to run the query.)
update user set password = 'whatever' where user = 'root' \g
(that will change your password for the root users)

[karl]

okay if my password is banana and the user is root what command i must enter ?

[MAGnUm]

Once you open it, you can run the following
use mysql
(tells the program to use the mysql database which contains all of the information)
select host, user, password from user \g
(the \g tells mysql to run the query.)
update user set password = 'banana' where user = 'root' \g
(that will change your password for the root users)

or better option w/ gui (mysql admin suite)

http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-administrator-1.0.3-alpha-win.zip/from/http://mysql.247available.com/

[karl]

thank for your help !

[MAGnUm]

gui tool is nice! btw your welcome.