Time: 2024-07-12 Friday 18:44:01
Author: Jackasher

mysql运维(CentOS7)

首先获取mysql的仓库

wget http://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm
rpm -ivh mysql80-community-release-el7-5.noarch.rpm
yum install mysql-community-server

然后下载

sudo yum install mysql-server --nogpgcheck

找到密码启动

cat /var/log/mysqld.log | grep password

启动后

 输入以下语句，进入mysql库：

use mysql
3. 更新域属性，’%’表示允许任意IP地址访问：

update user set host='%' where user ='root';
4. 执行以上语句之后再执行：

FLUSH PRIVILEGES;
5. 再执行授权语句：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;