This will helps when you forget MySQL root password and not able to access MySQL service on the server. Here are the steps to reset MySQL password : root@server [~] /etc/init.d/mysqld stop Now start MySQL server without password: root@server [~] mysqld_safe –skip-grant-tables & root@server [~] mysql After that you can get the mysql prompt then […]
This will helps when you forget MySQL root password and not able to access MySQL service on the server. Here are the steps to reset MySQL password : root@server [~] /etc/init.d/mysqld stop Now start MySQL server without password: root@server [~] mysqld_safe –skip-grant-tables & root@server [~] mysql After that you can get the mysql […]
Steps to reset mysql root password from mysql safe: # service mysqld stop # mysqld_safe –skip-grant-tables & That should start up mysql without the need for a root password. Once in, type >use mysql >UPDATE user SET password=PASSWORD(‘newpass’) WHERE user=’root’; >FLUSH PRIVILEGES; >quit That will reset the root password for you. Kill all old processes […]
You must be logged in to post a comment.