mysql 8 安装配置命令

mysql 8 安装配置命令

参考https://blog.youkuaiyun.com/kunzai6/article/details/81938613文章中的内容配置

rpm -qa|grep mysql
安装MySQL官方的Yum Repository https://dev.mysql.com/downloads/repo/yum/
wget -i -c http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
下载rpm包
yum -y install mysql80-community-release-el7-3.noarch.rpm
安装MySQL服务
yum -y install mysql-community-server
启动mysql服务：
systemctl start mysqld.service
重启：systemctl restart mysqld.service
停止：systemctl stop mysqld.service
查看状态：systemctl status mysqld.service
最后两行出现：代表启动成功。
Starting MySQL Server…
Started MySQL Server.

登录mysql
mysql -u root -p
初始密码默认是/var/log/mysqld.log，找到临时密码
cat /var/log/mysqld.log
重新设置密码
set global validate_password.policy=0;
set global validate_password.length=4;
ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘Hujun123#’;
SHOW VARIABLES LIKE ‘validate_password%’;
use mysql;
select user,host from user;
update user set host=’%’ where user=‘root’ and host=‘localhost’;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’;
FLUSH PRIVILEGES;

修改加密规则
mysql8新版本发布，安装后出现2059错误，原因为安装时选择了强加密规则caching_sha2_password
与之前的mysql5.7的mysql_native_password规则不同，navicate驱动目前不支持新加密规则
select user,host,plugin from user where user=‘root’;
#修改加密规则
ALTER USER ‘root’@’%’ IDENTIFIED BY ‘Hujun123#’ PASSWORD EXPIRE NEVER;
#更新一下用户的密码
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘Hujun123#’;
FLUSH PRIVILEGES;

创建用户
CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;