Friday 26 March 2010

Resetting mysql root password in Ubuntu

sudo apt-get autoremove rt3.8-apache2 rt3.8-db-mysql


Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal.    

1. Stop the MySQL Server.        sudo /etc/init.d/mysql stop     

2. Start the mysqld configuration.       

sudo mysqld --skip-grant-tables &     

3. Login to MySQL as root.       
mysql -u root mysql     

4. Replace YOURNEWPASSWORD with your new password!       
UPDATE user SET Password=PASSWORD('fuck') WHERE User='root'; FLUSH PRIVILEGES; exit;  

No comments:

Post a Comment