一、安装

yum install mysql mysql-server

二、检查是否开机自启动和设置开机自启动

[root@localhost ~]# systemctl list-unit-files|grep mysqld
mysqld.service disabled
mysqld@.service disabled
[root@localhost ~]# systemctl enable mysqld.service #设置开机启动
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.
[root@localhost ~]# systemctl list-unit-files|grep mysqld
mysqld.service enabled
mysqld@.service disabled

[root@localhost ~]# ps -ef|grep mysql # 查看是否启动MySQL服务
root 4311 32702 0 21:07 pts/4 00:00:00 grep —color=auto mysql
[root@localhost ~]# systemctl start mysqld.service #启动服务

三、设置密码

mysql

use mysql;

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;

FLUSH PRIVILEGES;

quit;

四、设置远程登陆

mysql -uroot -p
输入刚刚设置的密码

CREATE USER ‘root’@’%’ IDENTIFIED BY ‘123456’; //此操作mysql 8.0中必须加

GRANT ALL PRIVILEGES ON . TO ‘root’@’%’WITH GRANT OPTION; //任何远程主机都可以访问数据库

FLUSH PRIVILEGES;

quit;

五、设置防火墙

firewall-cmd —zone=public —add-port=3306/tcp —permanent

firewall-cmd —reload

systemctl restart mysqld