本次安装后未配置MySQL到环境变量,所以安装后的连接mysql命令用的是绝对路径地址
MySQL安装包:链接:https://pan.baidu.com/s/10XUPIC7IUVCCtsdXUax1bw 提取码:fmrv
- 将压缩文件解压到指定路径
D:\Program Files\mysql-5.7.32-winx64
- 新建并修改配置文件(D:\Program Files\mysql-5.7.32-winx64\my.ini)
- 配置文件内容(指定安装路径和数据存放目录)
[mysqld]
# set basedir to your installation path
# 路径也可以用 D:\\Program Files\\mysql-5.7.32-winx64
basedir=D:/Program Files/mysql-5.7.32-winx64
# set datadir to the location of your data directory
datadir=D:/Program Files/mysql-5.7.32-winx64/data
- 初始化data目录
# bin\mysqld --defaults-file=C:\my.ini --initialize --console
"D:\Program Files\mysql-5.7.32-winx64\bin\mysqld" --defaults-file="D:\Program Files\mysql-5.7.32-winx64\my.ini" --initialize --console
- 命令行窗口查看临时密码(初始化不带console参数时查看err日志)
[Note] A temporary password is generated for root@localhost: =_zJUAHdb7&M
- 安装mysql服务(管理员运行)
# "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" --install service_name --defaults-file=file_name
"D:\Program Files\mysql-5.7.32-winx64\bin\mysqld" --install MySQL57 --defaults-file="D:\Program Files\mysql-5.7.32-winx64\my.ini"
- 启动运行mysql
# 方式一 使用cmd命令
"D:\Program Files\mysql-5.7.32-winx64\bin\mysqld" --console
# 方式一 启动MySQL服务
net start MySQL57
- 连接mysql服务器
#根据提示输入密码(输入root的临时密码)
"D:\Program Files\mysql-5.7.32-winx64\bin\mysql" -u root -p
# 初始化时参数为 bin\mysqld --initialize-insecure --console
# 使用这种方式首次登陆 mysql -u root --skip-password
- 修改root用户密码
# 先登录连接mysql,然后修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root-password';
#创建本地用户
CREATE USER 'root'@'127.0.0.1' IDENTIFIED BY 'root-password';
CREATE USER 'root'@'::1' IDENTIFIED BY 'root-password';
- 删除MySQL服务
# 方式一
"D:\Program Files\mysql-5.7.32-winx64\bin\mysqld" --remove
# 方式二(MySQL57为安装服务时指定的服务名)
SC DELETE MySQL57
- mysql配置文件参考
[mysqld]
port = 3306
basedir=D:/Program Files/mysql-5.7.32-winx64
datadir=D:/Program Files/mysql-5.7.32-winx64/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8