MySQL 8.0.23 Password lost – CentOS 정복 -> Rocky

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

# systemctl stop mysqld

# systemctl stop mysqld

2. –skip-grant-tables

# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"

3. start mysqld

# systemctl start mysqld

# systemctl start mysqld

4. Login as root

# mysql -u root

# mysql -u root

5. Update the root user password

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword')
    -> WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword')

-> WHERE User = 'root' AND Host = 'localhost';

mysql> FLUSH PRIVILEGES;

mysql> quit

6. Stop mysql

# systemctl stop mysqld

# systemctl stop mysqld

7. Unset the mySQL envitroment option so it starts normally next time

# systemctl unset-environment MYSQLD_OPTS

# systemctl unset-environment MYSQLD_OPTS

8. Start mysql normally

# systemctl start mysqld

# systemctl start mysqld

7. Try to login

# mysql -u root -p

# mysql -u root -p