centos7安装mysql8.0
下载mysql源
https://dev.mysql.com/downloads/repo/yum/
选择对应版本
注意:Linux 8对应centos 8,需要下载Linux 7
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
安装mysql源
yum localinstall mysql80-community-release-el7-3.noarch.rpm
检测是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
输出
mysql-connectors-community/x86_64 MySQL Connectors Community 212
mysql-tools-community/x86_64 MySQL Tools Community 132
mysql80-community/x86_64 MySQL 8.0 Community Server 283
安装mysql
yum install mysql-community-server
注意:默认是安装mysql8.0,如需安装5.7版本,需切换版本
启动数据库
systemctl start mysqld
重启数据库
systemctl restart mysqld
查看启动状态
systemctl status mysqld
或
service mysqld status
设置开机启动
systemctl enable mysqld
systemctl daemon-reload
查看默认密码
grep 'temporary password' /var/log/mysqld.log
登录mysql
mysql -uroot -p
修改默认密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@123'
注意:密码需包含大小写、数字和特殊字符
查看密码策略(需要先修改默认密码)
show variables like '%validate_password%';
结果说明:
validate_password_policy:MEDIUM 密码策略,默认为MEDIUM策略
validate_password_dictionary_file 密码策略文件,策略为STRONG才需要
validate_password_length:8 密码最少长度8位
validate_password_mixed_case_count:1 大小写字符长度,至少1个
validate_password_number_count :1 数字至少1个
validate_password_special_char_count:1 特殊字符至少1个
修改密码策略(可选)
需要修改/etc/my.cnf下的validate_password_policy配置
validate_password_policy=0 0-low , 1-medium , 2 - strong
validate_password = off 设置成不需要密码策略
授权root远程访问
update user set host='%' where user ='root';
flush privileges;
查看数据库编码方式
SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';
创建用户
CREATE USER 'test'@'%' IDENTIFIED BY 'test';
允许用户远程连接
GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' WITH GRANT OPTION;