1,下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2,安装yum源
yum localinstall mysql57-community-release-el7-11.noarch.rpm
3,检查yum源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"
5,安装mysql
yum install mysql-community-server
6,启动mysql并查看其状态
systemctl start mysqld
systemctl status mysqld
7,设置mysql为系统服务,随系统启动而启动
systemctl enable mysqld
systemctl daemon-reload
8,查看mysql下root账号的默认密码
grep 'temporary password' /var/log/mysqld.log
9,默认配置文件路径
配置文件:/etc/my.cnf
日志文件:/var/log//var/log/mysqld.log
服务启动脚本:/usr/lib/systemd/system/mysqld.service
socket文件:/var/run/mysqld/mysqld.pid
11,进入mysql
mysql -u root -p
然后输入刚查看的密码
12,修改密码策略
mysql的密码策略分为三种:
0或LOW:Length
1或MEDIUM:Length; numeric, lowercase/uppercase, and special characters
2或STRONG:Length; numeric, lowercase/uppercase, and special characters; dictionary file
set global validate_password_policy=0;
13,修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
14,添加远程账号
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
15,常用命令
service mysqld restart/start/stop
网友评论