Dewan Codes - 160

Restore root access to MySQL on Drupal Server :

 

1. Log in to your server as the root user or a user with sudo privileges.

2. Stop the MySQL service by running the following command:

3. Start MySQL in safe mode with the --skip-grant-tables option to bypass the authentication:

4. Open a new terminal window and connect to the MySQL server:

5. Once connected to the MySQL server, switch to the MySQL database:

6. Update the root user's password with the following command:

7. Exit the MySQL shell:

8. Stop the MySQL service:

9. Start the MySQL service again:

Done