Installation text tutorial for mysql5.7.14 decompress version, text for mysql5.7.14

Installation text tutorial for mysql5.7.14 decompress version, text for mysql5.7.14

MySQL is divided into the Community edition (Community Server) and the Enterprise Edition (Enterprise). The difference is that the Community edition can be freely downloaded and free of charge, but the official Community Edition does not provide technical support, suitable for common users; the Enterprise Edition is charged and cannot be downloaded online. It provides more functions and more complete technical support.

There are two ways to install MySQL: msi and zip. The Installation Method of MySQL in msi format is silly. After the zip package is decompressed, MySQL can be used, but configuration is required before use.

1. decompress the file to your installation path. My installation path is D: \ MySQL:

2. After decompression, You need to configure the environment variables:

My computer-> properties-> advanced-> environment variables-> system environment variables-> path

Add the path of the bin folder under the installation directory to path, as shown in figure

3. Then we need to modify the MySQL configuration file, find the my-default.ini file under the installation directory, modify the basedir and datadir, such:

basedir = D:\MySQL\mysql5714  datadir = D:\MySQL\mysql5714\data

After modification, the file can be saved as my. ini.

4. Run cmd as an administrator to enter the command line window and enter the bin folder in the MySQL installation path:

Run the mysql-install command below:

If the installation is successful, a message is displayed.

Note: If you do not run as an administrator, an error is returned.

5. Run the net start mysql command after the installation is successful:

If the service cannot be started, there is no error report:

Cause: After the MySQL database is upgraded to version 5.7, it is somewhat different from the previous version. There is no data folder. We all know that the MySQL database files are saved in the data folder, some people on the Internet say that they have copied a data folder of version 5.6, which is not reliable. I also tried it and can log on, but cannot change the administrator password, the following is a standard solution.

After MySQL5.7 is installed, open the cmd command window and enter the bin directory in the MySQL installation directory. Then enter the following command and press Enter:

mysqld --initialize-insecure --user=mysql

After running the preceding command, MySQL creates a data folder and creates a default database. The logon username is root and the password is empty. The subsequent operations are the same as those of the previous version.

6. Repeat the commands in step 5 to open the service.

7. Run mysql-u root-p to enter mysql

Note: The first time you enter mysql, you do not need a password. Press enter to enter.

The above is a graphic installation tutorial for mysql5.7.14 unzip version. I hope it will help you. If you have any questions, please leave a message and I will reply to you in time. Thank you very much for your support for the help House website!