by 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!!)