vim /etc/yum.repos.d/mysql-community.repo
将以下代码复制进去
# Enable to use MySQL 5.7
[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
安装
yum install mysql-community-server
权限设置
chown mysql:mysql -R /var/lib/mysql
初始化
mysqld --initialize
启动
systemctl start mysqld
如果报错:
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
Do this and star mysql again
rm -rf /var/lib/mysql
查看运行状态
systemctl status mysqld
获取默认密码并登陆MySQL
grep 'temporary password' /var/log/mysqld.log
mysql -uroot -p
use mysql; #这一步如果报错,类似于下面这样,直接跳转下一步
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
重置密码(密码尽量包含大小写以及数字,否则可能设置不成功,切记:复杂
)
alter user 'root'@'localhost' identified by 'Abc123';
开启远程登录(如果需要远程连接的话)
select user,host from user;
修改前
user | host |
---|---|
mysql.session | localhost |
mysql.sys | localhost |
root | localhost |
update user set host='%' where user='root';
修改后
user | host |
---|---|
mysql.session | localhost |
mysql.sys | localhost |
root | % |
刷新权限
flush privileges;
其他参考命令
systemctl stop firewalld.service #停止firewall
systemctl disable firewalld.service #禁止firewall开机启动
firewall-cmd --zone=public --add-port=3306/tcp --permanent #开放端口
firewall-cmd --zone=public --remove-port=3306/tcp --permanent #关闭端口
firewall-cmd --reload #重新载入以生效
firewall-cmd --list-ports #查看开放端口列表