Home >Database >Mysql Tutorial >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!