When MySQL is deployed, the following solution is displayed: Table mysql. plugin doesn't exist. mysql. pluginexist

When MySQL is deployed, the following solution is displayed: Table mysql. plugin doesn't exist. mysql. pluginexist

Today, an installation-free MySQL instance is deployed.Table 'mysql. In in 'doesn' t existAfter a long time, I finally found a solution on the Internet. Now I want to share it with you:

System Environment:Win10 64-bit

MySQL version:Mysql-5.7.17-winX64

The deployment steps are as follows:

1: Modify the environment variable path, added value C: \ Program Files \ mysql-5.7.17-winX64 \ bin

2: Modify my-default.ini, rename TO my. ini, modify file content:

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

Create an empty data folder under the Home Directory "C: \ Program Files \ mysql-5.7.17-winX64;

3: Run cmd as the administrator. Enter mysqld-install to check whether the installation is successful. Enter net start mysql to prompt that the service fails to be started,

In this case, you can see five files in the data folder and open the file suffixed with. err. The prompt is: Table 'mysql. plugin 'doesn' t exist.

For this problemSolutionYes:

1. Copy my. ini to the \ bin folder;

2. Go to the \ bin directory in cmd, and enter mysqld -- initialize -- user = mysql -- console to execute this command to generate the database. Note that there is a temporary password. Remember to write it down;

3. start the Service net start mysql;

4. Run the mysql command: mysql-uroot-p and enter the password;

5. enter set password = password ('root') to change the root logon password;

I have successfully followed this operation and hope to help you.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.