Solution to Table MySQL. plugin doesn't exist prompt during mysql deployment

Source: Internet
Author: User

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;

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.