1.准备mysql 压缩包:mysql-5.7.24-winx64.zip
2.配置mysql 配置文件my.ini:
[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character-set-server=utf8
#basedir = "mysql包路径"
basedir = "D:\program file\mysql-5.7.24-winx64"
datadir = "D:\program file\mysql-5.7.24-winx64\data"
max_allowed_packet=100M
max_connections=1000
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
2.初始化mysql,并生成data文件夹:
2.1.快捷键:windows+Q打开windows快速搜搜输入cmd,右击管理员运行。
2.2. cmd窗口进入mysql包的bin目录下。
2.3.输入下面命令(初始化mysql,并生成root用户的初始密码打印到控制台):
mysqld --initialize --user=mysql --console
结果如下:
3.安装mysql服务:
mysqld -install
4.启动mysql服务
net start mysql
5.登陆MySQL修改初始密码123456:
mysql -u root -p
set password=password('123456')
6.最后得到一个mysql账户:root 密码:123456