MySQL 5.7 installation, mysql. Plugin ‘doesn’t exist error resolution

Today, the installation free version of MySQL was deployed, and the problem of table ‘mysql. Plugin’ doesn’t exist appeared. After a long time, I finally found a solution on the Internet. Now I’ll sort it out and share it with you

System environment: win10 64 bit

MySQL version: mysql-5.7.17-winx64

The steps of deployment are as follows:

1: Modify the environment variable path, and add the value of C: \ “program files \” mysql-5.7.17-winx64 \ “bin

2: Modify my-default.ini and rename it to my.ini. Modify the contents of the file

# basedir = C:\Program Files\mysql-5.7.17-winX64
# datadir = C:\Program Files\mysql-5.7.17-winX64\data

Create an empty data folder in the home directory “C:// program files/mysql-5.7.17-winx64”

3: The administrator runs CMD, and enters: mysqld – install to show that the installation is successful; Then enter: Net start Mysql to prompt that the service failed to start

At this point: go to the data folder to see five files, open the file with suffix. Err, and prompt: table ‘mysql. Plugin’ doesn’t exist

The solution to this problem is as follows:

1. Copy my.ini to the folder

2. In the CMD to the directory, and then enter mysqld — initialize — user = MySQL — console to execute this command to generate the library

3. Start the service net start mysql

4. Enter the MySQL command: MySQL – uroot – P, and enter the password just given

5. Input set password = password (‘root ‘) to modify the login password of root

Similar Posts: