一、rpm包
1、wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm(下载rpm)
2、rpm -ivh mysql-community-release-el7-5.noarch.rpm(安装rpm包)
3、yum install mysql-server (安装)
二、操作MySQL
1、service mysqld start(启动数据库)
2、service mysqld status(查看数据库状态)
3、mysql -u root -p(登录数据库),登陆密码使用 grep password /var/log/mysqld.log 查看
4、 set password = password(“ABC-abc123”) (修改成新的密码)
5 、GRANT ALL PRIVILEGES ON . TO ‘root‘@’%’ IDENTIFIED BY ‘ABC-abc123’ WITH GRANT OPTION;
flush privileges; (赋值权限)
6、exit
三、Linux防火墙
1、systemctl status firewalld.service(查看防火墙状态)
2、systemctl stop firewalld.service (关闭防火墙)
注意点:
centos7中防火墙的文件名有改变:
1、firewalld的基本使用
启动: systemctl start firewalld
关闭: systemctl stop firewalld
查看状态: systemctl status firewalld
开机禁用 : systemctl disable firewalld
开机启用 : systemctl enable firewalld