MySQL - Reset the root password

For users of the powerful database MySQL, access, as well as right to modify the admin (root) password is important, because both are required when installing and in situations when the master password is lost. The user must be connected to the root password to modify it but for reinitialising the password, this process can be skipped. Resetting the password is possible after connection to the MySQL database with the help of specific commands. In case the password is lost, then it is also possible to get access to the MySQLserver through a bypass of the authentication process. To reset the password under the latter condition, the server must be restarted to continue the process.

Issue: Root password is lost

To modify the existing root password, you must firstly be connected to the account. If you know the root password and just want to reinitialize it, you can skip this part. If you don't have the root password then follow the steps below: