Change MySQL 5.7.03 to MySQL 5.7.17 for installation and troubleshooting.

Change MySQL 5.7.03 to MySQL 5.7.17 for installation and troubleshooting.

1. How to install it?

1. [run]-> [cmd] Open the small black window. Go to the bin directory of MySQL installation directory my D: \ Program Files \ mysql-5.7.9-winx64 and enter mysqld-install ]. For example, the installation is successful.

2, open the MySQL installation directory, find the [my-default.ini], configure some simple information.

# These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.9-winx64 datadir = D:\Program Files\mysql-5.7.9-winx64\data port = 3306 # server_id = ..... 

3. Enter mysqld -- initialize to initialize mysql. The initialization process may take a while. If the following interface appears and the data folder in the MySQL installation directory contains content, the initialization is successful.

Because the new version of MySQL needs to initialize a write table at startup. Therefore, do not omit this step.

4. Enter mysqld-install to install the MySQL service.

5. start mysql [net start mysql]

6. log on to [mysql-uroot-p]

Without installing msyql-5.7.17-winx64.zip, a data directory is generated during step 2 initialization, the Default root Account initial password is in the. err file under the mysql-5.7.17 \ data directory

7. After logon, change the root account password to 'root'

# Modify the password of the root account alter user 'root' @ 'localhost' identified by 'root ';

Ii. How to restore a MySQL database of a lower version:

1. Cut the ibdata1 in the data DIRECTORY to other places first.

2. Copy the users folder and ibdata1 file under the data Directory of earlier versions to the data directory of later versions of mysql.

At this time, the copied users library can be used, but the database in the higher version cannot be used (because the ibdata1 file is of a lower version)

3. Restart mysql and save the users database as a. SQL file.

4. Replace the earlier version of ibdata1 with the later version of ibdata1 (currently, later versions can be used, earlier versions cannot be used, and ibdata1 is later)

5. Restart msyql and create a database (users, the database name can be changed). Open the. SQL file generated in step 5 of MySQL Workbench for execution.

Summary

The above section describes how to change the installation process from MySQL 5.7.03 to MySQL 5.7.17 and how to locate the problem. I hope this will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!