Step #2: Start MySQL Server In Safe Mode With –skip-grant-tables # mysqld_safe -skip-grant-tables & Sample output: Stopping MySQL database server: mysqld. Step #1: Stop MySQL Service/Process # /etc/init.d/mysqld stop Connect MySQL server as the root user.įollow the below command to do the above steps. Start MySQL server in safe mode with – -skip-grant-tables options so that it will not ask for a password.ģ. You can recover MySQL database root password using the following five easy steps:Ģ. If you have forgotten the MySQL root password you will get this error “ ERROR 1045 (28000): Access denied for user (using password: YES)”. In this article I will explain how to recover MySQL root password. Step #4: Update/Set New MySQL Root User Password.Step #3: Connect MySQL Server Using MySQL Client.Step #2: Start MySQL Server In Safe Mode With –skip-grant-tables.
0 kommentar(er)
