1、yum安装
1）卸载mariadb
rpm -qa | grep mariadb | xargs rpm -e --nodeps
2）下载msql5.7 yum源
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
3）安装yum源
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
4）安装mysql
yum -y install mysql-server
5）启动mysql
service mysqld start
6）查看root用户密码
grep 'temporary password' /var/log/mysqld.log
7）执行mysql初始化脚本
mysql_secure_installation
8）输入新密码（至少12个字符，至少包含一个大写字母有，一个小写字母，一个数字，一个特殊字符）
9）配置root用户远程访问权限
mysql> grant all privileges on *.* to 'root' @'%' identified by '@123456Qa';
mysql> flush privileges;
10）安装mysql驱动
（1）将mysql-connector-java-5.1.27-bin.jar拷贝到/usr/share/java路径下，并重命名
mv mysql-connector-java-5.1.27-bin.jar mysql-connector-java.jar
（2）分发驱动
xsync /usr/share/java
2、rpm安装
- 卸载mariadb
rpm -qa | grep mariadb | xargs rpm -e --nodeps
- 导入rpm包
- 检查
必须有如下两个包
rpm -qa|grep libaio
rpm -qa|grep net-tools
- 授权 chmod -R 777 /tmp
- 安装mysql
rpm -ivh mysql-community-common-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.16-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.16-1.el7.x86_64.rpm
- 查看版本
mysqladmin --version
- 初始化服务
mysqld --initialize --user=mysql
- 查看密码
cat /var/log/mysqld.log
root@localhost: 后面就是初始化的密码
- 相关服务
启动：systemctl start mysqld.service
停止：systemctl stop mysqld.service
- 登录修改密码
mysql -uroot -p
ALTER USER 'root'@'%' IDENTIFIED BY 'new_password';
- 修改字符集
vim /etc/my.cnf
在最后加上中文字符集配置
character_set_server=utf8
并重启
systemctl restart mysqld.service
- 授权远程连接
grant all privileges on . to root@'%' identified by 'root';
3、问题
1）Access denied for user 'root'@'localhost' (using password: YES)
1.，vi /etc/my.cnf
在最尾部加上
skip-grant-tables
保存
3，启动mysql
systemctl start mysqld.service
4，登录musql
mysql -u root
此处注意不要加-p
5,修改密码，mysql5.7用此语法
use mysql ;
update mysql.user set authentication_string=password('123456') where user='root' ;
6,回到第二步骤去掉加上的
skip-grant-tables
保存 重启mysql就ok了
2）密码安全策略
validate_password_policy类型
| Policy | Tests Performed |
|---|---|
0 or LOW |
Length |
1 or MEDIUM |
Length; numeric, lowercase/uppercase, and special characters |
2 or STRONG |
Length; numeric, lowercase/uppercase, and special characters; dictionary file |
修改策略方式
set global validate_password_policy=0;
