CentOS7安装 MySQL8

CentOS安装 MySQL8

1、在MySQL官网中查找YUM源rpm安装包: http://dev.mysql.com/downloads/repo/yum/ 

2、下载rpm安装包: wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3、安装mysql源: yum localinstall mysql80-community-release-el7-3.noarch.rpm

4、安装mysql: yum install mysql-community-server

5、启动mysql服务:  systemctl start mysqld

6、设置开机启动: systemctl enable mysqld; systemctl daemon-reload;

7、查找初始密码: grep 'temporary password' /var/log/mysqld.log

8、本地MySQL客户端登录: mysql -uroot -p

9、修改密码: ALTER USER 'root'@'localhost' IDENTIFIED BY  'password';

10、创建远程用户 CREATE USER 'name'@'%' IDENTIFIED BY 'password';

11、远程用户授权命令:GRANT privileges ON databasename.tablename TO 'username'@'host'

   GRANT ALL ON *.* TO 'username'@'%';

   ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

12、刷新用户权限: flush privileges;

99、 彻底卸载mysql: yum remove mysql-community-server