mysql5.7.18解压版启动mysql服务，具体内容如下
1.下载mysql社区版
2.解压到D:\Program Files
3.在D:\Program Files\mysql-5.7.18-winx64\bin下，新建文件my.ini,内容如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
[client]port=3306default-character-set=utf8[mysqld]bind-address = 127.0.0.1port=3306character_set_server=utf8basedir ="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=100table_open_cache=256query_cache_size=1Mtmp_table_size=32Mthread_cache_size=8innodb_data_home_dir="D:\Program Files\mysql-5.7.18-winx64\data\"innodb_flush_log_at_trx_commit =1innodb_log_buffer_size=128Minnodb_buffer_pool_size=128Minnodb_log_file_size=10Minnodb_thread_concurrency=16innodb-autoextend-increment=1000join_buffer_size = 128Msort_buffer_size = 32Mread_rnd_buffer_size = 32Mmax_allowed_packet = 32Mexplicit_defaults_for_timestamp=truesql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" |
4.配置C:\WINDOWS\system32\drivers\etc\hosts，默认是注释掉的，去掉注释：
|
1
|
127.0.0.1 localhost |
5.在D:\Program Files\mysql-5.7.18-winx64目录下新建data文件夹，必须为空。
6.打开cmd，cd到D:\Program Files\mysql-5.7.18-winx64\bin，执行如下命令
|
1
2
|
mysqld --initialize-insecuremysqld -install |
7.启动mysql服务，如果没有启动的话.net start mysql。
8.在cmd中，使用命令mysql -u root -p,回车进入mysql>命令提示符。
9.修改root密码
|
1
|
mysql> set password=password('123456'); |
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
