1解压
2.创建data目录
3.配置路径“my-default.ini”
basedir=D:\MySQL\mysql-5.7.11-winx64
DD:\MySQL\mysql-5.7.11-winx64\data
4.配置环境变量
path+=;D:\MySQL\mysql-5.7.11-wicdnx64\bin
5.初始化mysql 以管理员身份运行CMD
D:
cd D:\MySQL\mysql-5.7.11-winx64\bin
mysqld --initialize-insecure --user=mysql
6.添加系统服务
mysqld -install MySQL --defaults-file="D:\MySQL\mysql-5.7.11-winx64\my-default.ini"
7.启动mySQL
net start mysql
8. 设置root密码(可省略)
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
9.创建用户
CREATE USER 'gz_hw_score'@'%' IDENTIFIED BY 'rochern.com';
10.用户授权
GRANT ALL ON *.* TO 'gz_hw_score'@'%';
2.创建data目录
3.配置路径“my-default.ini”
basedir=D:\MySQL\mysql-5.7.11-winx64
DD:\MySQL\mysql-5.7.11-winx64\data
4.配置环境变量
path+=;D:\MySQL\mysql-5.7.11-wicdnx64\bin
5.初始化mysql 以管理员身份运行CMD
D:
cd D:\MySQL\mysql-5.7.11-winx64\bin
mysqld --initialize-insecure --user=mysql
6.添加系统服务
mysqld -install MySQL --defaults-file="D:\MySQL\mysql-5.7.11-winx64\my-default.ini"
7.启动mySQL
net start mysql
8. 设置root密码(可省略)
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
9.创建用户
CREATE USER 'gz_hw_score'@'%' IDENTIFIED BY 'rochern.com';
10.用户授权
GRANT ALL ON *.* TO 'gz_hw_score'@'%';