MySQL deployment prompts Table mysql. plugin doesn 't exist solution
- 2021-08-12 03:51:58
- OfStack
Today, the installation-free version of MySQL was deployed, and the problem of Table 'mysql. plugin' doesn 't exist appeared. After a long time of distress, I finally found a solution on the Internet. Now I will sort it out and share it with you:
System environment: Win10 64-bit
MySQL version: mysql-5. 7.17-winX64
The deployment steps are as described on the Internet:
1: Modify the environmental variable path and add value C:\ Program Files\ mysql-5. 7.17-winX64\ bin
2: Modify my-default. ini, rename my. ini, modify file contents:
# 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: The administrator runs cmd, and inputs: mysqld-install to show that the installation is successful; Re-enter: net start mysql, indicating that the service failed to start,
At this time: See 5 files under the data folder, open the file with the suffix. err, and prompt: Table 'mysql. plugin' doesn 't exist
The solution to this problem is:
1. Copy my. ini to the\ bin folder;
2. Execute this command in the cmd to\ bin directory, and then type mysqld-initialize-user=mysql-console to generate the library. Note that there is a temporary password, which should be written down;
3. Start the service net start mysql;
4. Enter the mysql command: mysql-uroot-p, and enter the password just now;
5. Enter set password = password ('root') to change the login password of root;
I have succeeded in following this operation, hoping to be helpful to you.