What to do with mysql error 1248

Mysql error 1248 solution: first add [skip-grant-tables] to the mysql configuration file; then restart mysql, reset the password and refresh the permission table; then comment [skip- grant-tables]; finally restart mysql.

Related free learning recommendations: mysql database( Video)

Mysql error 1248 solution:

1. First, skip the permissions and configure the mysql configuration file (linux--> my.cnf) [mysqld] Add skip-grant-tables, you can log in without a password, as shown in the figure.

2. Then restart mysql.

#3. Then reset the password and refresh the permission table.

#4. Then comment skip-grant-tables in the mysql configuration file.

5. Finally, restart mysql and the problem will be solved.

The above is the detailed content of What to do with mysql error 1248. For more information, please follow other related articles on the PHP Chinese website!