CentOS7安装mysql rpm包

一、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

坚持原创技术分享,您的支持将鼓励我继续创作!
-------------本文结束感谢您的阅读-------------
分享到:
0%