Recover your MySQL password
What if you’ve forgotten your MySQL root user password? This could be quite the predicament … had the developers not thought of that eventuality. In order to recover the password, you simply have to follow these steps:
- Stop the MySQL server process with the command sudo service mysql stop
- sudo mkdir /var/run/mysqld
- sudo chown mysql:mysql /var/run/mysqld
- Start the MySQL server with the command sudo mysqld_safe –skip-grant-tables –skip-networking &
- Connect to the MySQL server as the root user with the command mysql -u root
At this point, you need to issue the following MySQL commands to reset the root password:
mysql> use mysql; mysql> update user set authentication_string=password('NEWPASSWORD') where user='root'; mysql> flush privileges; mysql> quit
Nejnovější komentáře