The server executes the contents of the file named by the -init-file option at startup, changing the account password.Īfter the server has started successfully, delete /home/me/mysql-init.
#Mysql recover root password how to
Start the MySQL server with the special -init-file option: shell> /usr/sbin/mysqld -init-file=/home/me/mysql-init & How to recover mysql password duplicate Ask Question Asked 7 years, 9 months ago Modified 7 years, 9 months ago Viewed 14k times 3 This question already has answers here : How to change root password for mysql and phpmyadmin (3 answers) Closed 4 years ago. If you are not logged in as mysql (the user the server runs as), make sure that the file has permissions that permit mysql to read it. Depending on the MySQL or MariaDB server version you are running on your system, you will need to use different commands to recover the root password. The file contains the password, so do not save it where it can be read by other users. This example names the file /home/me/mysql-init. SET PASSWORD FOR = PASSWORD('MyNewPass') To do this, type the following command, replacing new-password. Replace the password with the password that you want to use. Log into MySQL using the following command: mysql At the mysql> prompt, reset the password. Set new password for your root user by running UPDATE er SET PasswordPASSWORD ('newpassword') WHERE User'root' in phpMyAdmin in the mysql database (or just leave it like this if MySQL cannot be accessed from remote hosts. You did that with: su /etc/init.d/mysql stopĬreate a text file containing the following statement on a single line. Edit my.ini and insert skip-grant-tables below mysqld Restart MySQL. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql).
0 kommentar(er)
