What should I do if I cannot log in locally after modifying mysql permissions?

Solution to the problem of being unable to log in locally after modifying mysql permissions: First execute the [service mysql stop] command to shut down the mysql service; then execute the [mysqld_safe --skip-grant-tables &] command to skip the permission tables; finally restart Just set a password.

Solution:

(Learning video recommendation:mysql video tutorial)

Stop first mysql service

service mysql stop

Then skip the permission table

Execute the command:

(Related recommendations:mysql tutorial)

mysqld_safe --skip-grant-tables &

This way It won't prevent us from logging in.

Finally reset the password.

The above is the detailed content of What should I do if I cannot log in locally after modifying mysql permissions?. For more information, please follow other related articles on the PHP Chinese website!