进入D:\software\mysql-8.0.23-winx64\bin创建my.ini
[mysqld]
basedir=D:\softwareWork\mysql-8.1.0-winx64
datadir=D:\softwareWork\mysql-8.1.0-winx64\data
port=3306
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8
以管理员的身份运行cmd(重点)
进入到mysql8.0.23的bin目录。如:cd D:\software\mysql-8.0.23-winx64\bin
mysql初始化
mysqld --initialize-insecure --user=mysql
安装mysql8
mysqld --install
启动mysql
net start mysql
登录mysql。初始密码为空,直接回车即可。
mysql -uroot -p
mysql> 输入以下命令
修改root密码及加密方式
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456' PASSWORD EXPIRE NEVER;
刷新(必须刷新)
FLUSH PRIVILEGES;
新建用户
新建用户并修改加密方式
mysql> 输入以下命令
创建x用户密码为123456及修改加密方式
CREATE USER 'x'@'%' IDENTIFIED WITH mysql_native_password BY 'x' PASSWORD EXPIRE NEVER;
授权x用户所有权限(WITH GRANT OPTION表示可以给其它人授权)
GRANT all on *.* to 'x'@'%' WITH GRANT OPTION;
刷新(最后一步一定是刷新)
FLUSH PRIVILEGES;
退出,重新登录
exit;