Solution to Table MySQL. plugin doesn't exist prompt during mysql deployment
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.
The solution to this problem is:
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;