Linux下安装Mysql

Linux下安装Mysql

1. 更新yum

yum update -y

2. 下载

yum wget -i -c https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3. 安装mysql 8.0

yum -y install mysql80-community-release-el7-3.noarch.rpm

4. 进行安装

yum -y install mysql-community-server --nogpgcheck

5. 启动mysql

systemctl start mysqld

6. 查看Mysql默认密码

grep “password” /var/log/mysqld.log

7. 登录

mysql -uroot -p

8. 修改密码

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘sinx=cosxtanx’;

grant all privileges on . to ‘root’@‘localhost’;

9. 使用mysql库

use mysql;

10. 允许远程连接

CREATE user ‘root’@‘%’’ IDENTIFIED BY ‘sinx=cosxtanx’;

update user set Grant_priv=‘Y’,Super_priv=‘Y’ where user = ‘root’ and host = ‘%’;

[comment]: <>(设置权限)
grant all privileges on . to ‘root’@‘%’;

[comment]: <>(刷新)
flush privileges

12. 卸载

yum remove mysql mysql-server mysql-libs compat-mysql80

rm -rf /var/lib/mysql/

rm /etc/my.cnf