mysql passwd

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql passwd

Postby karl » 12. April 2004 21:22

how do can i remove mysql password ?
karl
 
Posts: 20
Joined: 22. February 2004 17:26
Location: Canada , Montreal

Postby MAGnUm » 13. April 2004 17:06

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)
~~:M A G n U m:~~
(Disclaimer: if any of this info is confusing or vague tough, its free!!)
User avatar
MAGnUm
 
Posts: 151
Joined: 16. October 2003 18:08
Location: USA

Postby karl » 14. April 2004 22:19

okay if my password is banana and the user is root what command i must enter ?
karl
 
Posts: 20
Joined: 22. February 2004 17:26
Location: Canada , Montreal

Postby MAGnUm » 15. April 2004 14:45

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/
~~:M A G n U m:~~
(Disclaimer: if any of this info is confusing or vague tough, its free!!)
User avatar
MAGnUm
 
Posts: 151
Joined: 16. October 2003 18:08
Location: USA

Postby karl » 18. April 2004 22:52

thank for your help ! :)
karl
 
Posts: 20
Joined: 22. February 2004 17:26
Location: Canada , Montreal

Postby MAGnUm » 20. April 2004 15:09

gui tool is nice! btw your welcome.
~~:M A G n U m:~~
(Disclaimer: if any of this info is confusing or vague tough, its free!!)
User avatar
MAGnUm
 
Posts: 151
Joined: 16. October 2003 18:08
Location: USA


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 70 guests