طريقة إستعادة Root MySQL Password

[ملك الفضائيات]

طريقة إستعادة الروت

Stop the MySQL service

(Ubuntu and Debian) Run the following command:
Bash:

sudo /etc/init.d/mysql stop

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command:
Bash:

sudo /etc/init.d/mysqld stop


Start MySQL without a password

Run the following command. The ampersand (&) at the end of the command is required.
Bash:

sudo mysqld_safe --skip-grant-tables &


Connect to MySQL

Run the following command:
Bash:

mysql -uroot


Set a new MySQL root password

Run the following command:
Bash:

use mysql;
update user set authentication_string=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit

Note: Change mynewpassword with your own password

Stop and start the MySQL service
(Ubuntu and Debian) Run the following commands:
Bash:

sudo /etc/init.d/mysql stop
...
sudo /etc/init.d/mysql start

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands:
Bash:

sudo /etc/init.d/mysqld stop
...
sudo /etc/init.d/mysqld start


Log in to the database

Test the new password by logging in to the database.
Bash:

mysql -u root -p

Enter your new password when prompted.