Mysql 5.7.18 zip version installation and configuration method graphic tutorial (win7), 5.7.18win7

Mysql 5.7.18 zip version installation and configuration method graphic tutorial (win7), 5.7.18win7

Mysql5.7.18zip is installed in windows. It can be decompressed, initialized, and used after some password modification settings. To connect remotely, you need to change the host value of the User table to '% ', disable the firewall for installing the MySQL host.

Download mysql5.7.18-win64.zip (the latest version) from mysql and decompress it.

The decompressed directory is as follows:

In the mysql extract directory, create a configuration file for my. ini and configure it as follows:

2. In the mysql installation directory, first create the data directory, then enter the bin directory, and perform initialization.

Initialization must be performed. Otherwise, an error will be reported when the service is started.

$ mysqld --initialize

After successful initialization, the data directory is as follows:

After successful initialization, A xxx. err file will be generated under the data directory. This xxx is the name of the computer. The random logon password generated by mysql as the root user is recorded here.

If Initialization is not performed, an error occurs when mysql is started. Delete the installed Service first.

$ mysqld -remove

3. You can install mysql in the system service and then start the system service.

$ mysqld -install$ net start mysql

You can also right-click a computer and choose manage> services> Applications> services to find the MySQL service and start it.

4. log on to mysql as the root user and use the random password generated during initialization.

In some versions, After zip installation, the initial password is not set for the root user. For the first login, enter mysql-uroot-p and press enter to log on. However, a random password is generated by default during initialization of version 5.7.

Supplement:

To remotely connect to mysql, you need to change the root user's host to '%', or authorize a new user, set the host to '%', and disable the local firewall.

Disable Firewall:

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