美文网首页
centos7.3 安装mysql

centos7.3 安装mysql

作者: 霍运浩 | 来源:发表于2019-02-28 14:58 被阅读0次

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

相关文章

网友评论

      本文标题:centos7.3 安装mysql

      本文链接:https://www.haomeiwen.com/subject/sdvhuqtx.html