Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to install and configure the green version of mysql 5.7.18. It is very detailed and has a certain reference value. Friends who are interested must finish reading it!

1. Download the mysq5.7.18 green version first, then extract it and put it in a directory. My extracted mysql is placed in "D:\ mysql\ mysql-5.7.18-winx64" (this root directory called myql).

2. Create the device in the myql root directory. As shown in the figure:

3. Edit the "my.ini" file; my configuration is:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # installation directory basedir = D:\ mysql\ mysql-5.7.18-winx64# data storage directory datadir = D:\ mysql\ mysql-5.7.18-winx64\ data# below is my own tmpdir = D:\ mysql\ mysql-5.7.18-winx64\ datasocket = D:\ mysql\ mysql-5.7.18-winx64\ mysql.sock# port port The default storage engine default-storage-engine=INNODB# to use when creating a new table is the default storage engine default-storage-engine=INNODB# to avoid external locking (default is ON) the maximum number of skip-external-locking# connections max_connections = 10 "the maximum number of connections for a single memory table limits max_heap_table_size = the size of the sort buffer allocated by 64M# for each thread Sort_buffer_size = buffer size of 8M#join join table operation Set up according to the actual business Default 8Mjoin_buffer_size = 32M# sql query cache. If the submitted query is the same as a query in several times and exists in the query cache, the result query_cache_size = 64m in the cache will be returned directly.

4. Use the cmd command to enter the bin directory under the mysql root directory

(1) execute mysqld-initialize-insecure-user=mysql initialization data directory (no password initialization)

(2) perform mysqld-install installation as a service. If it has been installed before, uninstall it (mysqld-remove) and then perform the installation.

(3) start the service: net start mysql; or by right-clicking computer-Management-Service, find MYSQL and set it to automatic.

(4) access without password: mysql-u root-p

(5) change the password: SET PASSWORD = 'password'

5. Configure all machines to connect to the server

(1) use mysql

(2) select host,user from user where user='root'

(3) update user set host ='% 'where user =' root'

(4) flush privileges

(5) select host,user from user where user='root'

Problem: if you find that other computers (in the same local area network) still can't connect, add port 3306 to the exception in the firewall that comes with window.

The above is all the contents of the article "how to install and configure the Green version of mysql 5.7.18". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.