mysql5.7.18 decompressed version to start mysql service

The decompressed version of mysql5.7.18 starts the mysql service. The specific contents are as follows

1. Download MySQL Community Edition

2. Unzip to D:\Program Files

3. Create a new file my.ini in D:\Program Files\mysql-5.7.18-winx64\bin with the following content:

 [client]
 port=3306
 default-character-set=utf8
 
 [mysqld]
 bind-address = 127.0.0.1
 port=3306
 character_set_server=utf8
 basedir = "D:\Program Files\mysql-5.7.18-winx64"
 datadir = "D:\Program Files\mysql-5.7.18-winx64\data"
 tmpdir = "D:\Program Files\mysql-5.7.18-winx64\data"
 socket = "D:\Program Files\mysql-5.7.18-winx64\data\mysql.sock"
 log-error="D:\Program Files\mysql-5.7.18-winx64\data\mysql_error.log"

 max_connections=100
 table_open_cache=256
 query_cache_size=1M
 tmp_table_size=32M
 thread_cache_size=8

 innodb_data_home_dir="D:\Program Files\mysql-5.7.18-winx64\data\"
 innodb_flush_log_at_trx_commit = 1
 innodb_log_buffer_size=128M
 innodb_buffer_pool_size=128M
 innodb_log_file_size=10M
 innodb_thread_concurrency=16
 innodb-autoextend-increment=1000

 join_buffer_size = 128M
 sort_buffer_size = 32M
 read_rnd_buffer_size = 32M
 max_allowed_packet = 32M
 explicit_defaults_for_timestamp=true

 sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

4. Configure C:\WINDOWS\system32\drivers\etc\hosts. It is commented out by default. Remove the comments:

127.0.0.1 localhost

5. Create a new data folder in the D:\Program Files\mysql-5.7.18-winx64 directory. It must be empty.

6. Open cmd, cd to D:\Program Files\mysql-5.7.18-winx64\bin, and execute the following command

mysqld --initialize-insecure
mysqld -install

7. Start the MySQL service. If it is not started, use .net start mysql .

8. In cmd, use the command mysql -u root -p and press Enter to enter the mysql> command prompt.

9. Change the root password

mysql> set password=password('123456');

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:

Solution to the mysql service not starting
MySQL service 1067 error multiple solutions sharing
Causes and solutions for invalid service name when starting MySQL service under Windows 7
Solve phpmyadmin #2002 Unable to log in to MySQL server
Summary of Cause Analysis and Solutions for Slow Query of MySQL Server
Quick solution to MySQL service startup failure under CentOS 7
phpmyadmin error: #2003 Unable to log in to MySQL server solution
Solution to MySQL server process CPU usage 100%
Summary of solutions to mysql service unexpected stop 1067 error
Solution to the failure of MySQL service startup during MySQL 5.7.18 installation

<<: Solve the problem of regular automatic file deletion by crontab+shell script under Centos7

>>: JS asynchronous execution principle and callback details