1.删除所有的mysql、mariadb

yum remove mariadb-libs

2.安装必要依赖

wget http://mirror.centos.org/centos-7/7.5.1804/os/x86_64/Packages/libaio-0.3.109-13.el7.x86_64.rpm

rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm

yum -y install numactl

yum install -y net-tools

3.安装mysql

rpm -ivh mysql-community-common-8.0.12-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.12-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.12-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.12-1.el7.x86_64.rpm

4.初始化mysql

mysqld –initialize –user=mysql

5.获取mysql初始化密码

cat /var/log/mysqld.log

6.启动mysql服务

 

systemctl start mysqld.service

或者

service mysqld start

 

或者使用mysql启动脚本

/etc/inint.d/mysqld start

7.登陆mysql修改用户密码

8.0之前使用

alter user ‘root’@’%’ identified by ‘123456’;

 

8.0之后使用

ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘YUwei.12345’;

8.防火墙放行3306端口

/sbin/iptables -I INPUT -p tcp –dport 3306 -j ACCEPT

9.创建新用户

CREATE USER `shs`@`%` IDENTIFIED BY ‘cJcow9sLKurO’;

10.授予权限

GRANT ALL PRIVILEGES ON *.* TO `shs`@`%`;