Forgotton MySQL Root Password

[Chris1989]

Is there ayway to reset the installation of MySql so i can start from scratch. Its running on my CentOS 5 server.

I have no databases and dont use MySQL for anything at the moment but need to start doing so.

I tried 'yum remove mysql' then 'yum install mysql' but that doesnt seem to reset the passwords etc.

Any help would be appreciated.

Cheers.

[elija]

Firstly you will need root access to the server

Login or su to root
Stop the MySQL Server
And then from the command link execute mysqld --skip-grant-tables
You can then run mysql from the command line - execute mysql -u root (You won't be asked for a password)
In Mysql run use mysql;
And then UPDATE user SET password = pasword("YOUR_PASSWORD") WHERE user = 'root';
Run exit;

Stop the mysql server and restart it normally

[Chris1989]

Firstly you will need root access to the server

Login or su to root
Stop the MySQL Server
And then from the command link execute mysqld --skip-grant-tables
You can then run mysql from the command line - execute mysql -u root (You won't be asked for a password)
In Mysql run use mysql;
And then UPDATE user SET password = pasword("YOUR_PASSWORD") WHERE user = 'root';
Run exit;

Stop the mysql server and restart it normally

Sorry for being a total newb but i tried what you said;

became root then

#service mysqld stop

stopped the server, then

#mysqld --skip-grant-tables
or
#execute mysqld --skip-grant-tables

brings the unknown command error

sorry if I am just being stupid!

Cheers.

[elija]

mysqld may not be in your path. Try /etc/init.d/mysqld --skip-grant-tables

If that doesn't work you can see where mysqld is by running which mysqld