Mysql 5.7.19 winx64 ZIP Archive installation and usage summary, 5.7.19winx64

Mysql 5.7.19 winx64 ZIP Archive installation and usage summary, 5.7.19winx64

I learned how to install MySQL today. I encountered some problems in the process. I checked several related articles and solved them. I recorded them for your reference.

1. Download

Https://dev.mysql.com/downloads/mysql/

Http://www.bkjia.com/softs/451120.html

Select a suitable version. Archive indicates that you can decompress the package directly after downloading the file. It is convenient to install Archive without installation.

2. Create the file my. ini in the root directory of MySQL (not available before) and add the following content to the file.

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 = 3306 # set the mysql installation directory basedir = E: \ Databases \ mysql \ mysql-5.7.19-winx64 # Set the data storage directory of the mysql database datadir = E: \ Databases \ mysql \ mysql-5.7.19-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # when creating a new table default-storage-engine = INNODB # password-free logon to skip-grant-tables

The last line was added later, because I had to log on with a password, but I didn't know it. Then I added the last sentence to the my. ini file, so I can log on without a password.

3. Find the Path in the environment variable and add the bin Path of mysql.

For example, mine is: "; E: \ Databases \ mysql \ mysql-5.7.19-winx64 \ bin"

4. Run cmd as an administrator. You must run cmd as an administrator. You can view the running methods of your system as an administrator.

5. Run the following command:

mysqld --initialize mysqld install net start mysql mysql -u -root

Summary

The above section describes how to install and use Mysql 5.7.19 winx64 ZIP Archive. 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!