MySQL解压版配置方法

1.下载

https://downloads.mysql.com/archives/community/

2. 创建my.ini文件。复制如下文档

[mysqld]
character-set-server=utf8
bind-address = 0.0.0.0
port = 3306
basedir=D:/mysql-5.7.24-winx64
datadir=D:/MySQL_Data_DFN_FT/data
max_connections=2000
default-storage-engine=INNODB
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[client]
default-character-set=utf8

3. 拷贝到解压目录

4.添加环境变量

管理员方式运行CMD，安装服务。mysqld --install mysql

5. 初始化data文件夹，mysqld --initialize --user=root --console，（如何设置mysql的默认密码）

my.ini中：datadir=D:/MySQL_Data_DFN_FT/data，自己先创建MySQL_Data_DFN_FT的目录，data文件就会自动生成到这里。

自动生成root,的登录密码。

6. 启动服务， net start mysql

C:\WINDOWS\system32>net start mysql
mysql 服务正在启动 .
mysql 服务已经启动成功。

7. 登录root用户。mysql -uroot -pafyysw,7exwG

C:\WINDOWS\system32>mysql -uroot -pafyysw,7exwG
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.24

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

8. 修改密码

mysql> set password =password('root');//括号里面的root就是密码
Query OK, 0 rows affected, 1 warning (0.00 sec)

9.退出

mysql> exit
Bye

10.测试登录 C:\WINDOWS\system32>mysql -uroot -proot

C:\WINDOWS\system32>mysql -uroot -proot
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.7.24 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
Bye