Centos7下使用yum安装mysql数据库的详细教程(增强版)

$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

$ sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

$ sudo yum install mysql-server

$ mysql -u root

$ sudo chown -R openscanner:openscanner /var/lib/mysql

$ service mysqld restart

firewall-cmd --permanent --zone=public --add-port=3306/tcp
firewall-cmd --permanent --zone=public --add-port=3306/udp
firewall-cmd --reload

mysql_secure_installation;

--实施环境用户
CREATE USER 'dbuser'@'%' IDENTIFIED BY '123456';
GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'dbuser'@'%';
--管理员用户
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'admin'@'%';
flush privileges;

mkdir /home/data
--关闭mysql服务进程
systemctl status mysqld
mv /var/lib/mysql /home/data

datadir=/home/data/mysql
socket=/home/data/mysql/mysql.sock
socket=/home/data/mysql/mysql.sock