mysqld_safe: command not found
remark
8.0.23 MySQL
A explanation for the “mysqld_safe not found” error and what you can do to reset mysql root password in system
1. stop mysqld
|
1 2 3 |
# systemctl stop mysqld |
2. –skip-grant-tables
|
1 2 3 |
# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" |
3. start mysqld
|
1 2 3 |
# systemctl start mysqld |
4. Login as root
|
1 2 3 |
# mysql -u root |
5. Update the root user password
|
1 2 3 4 5 6 |
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') -> WHERE User = 'root' AND Host = 'localhost'; mysql> FLUSH PRIVILEGES; mysql> quit |
6. Stop mysql
|
1 2 3 |
# systemctl stop mysqld |
7. Unset the mySQL envitroment option so it starts normally next time
|
1 2 3 |
# systemctl unset-environment MYSQLD_OPTS |
8. Start mysql normally
|
1 2 3 |
# systemctl start mysqld |
7. Try to login
|
1 2 3 |
# mysql -u root -p |