系统初始化

sed -i 's/enforcing/disabled/' /etc/selinux/config 
setenforce 0 
systemctl stop firewalld
systemctl disable  firewalld
yum install -y ntpdate vim net-tools lrzsz wget telnet iptraf unzip sysstat nc
/usr/sbin/ntpdate -u time.windows.com >/dev/null 2>&1  && clock -w >/dev/null 2>&1
echo "*/1 * * * * /usr/sbin/ntpdate -u time.windows.com >/dev/null 2>&1  && clock -w >/dev/null 2>&1 ">>/var/spool/cron/root

1、卸载mariadb

rpm -qa|grep postfix |xargs rpm -e
 
rpm -qa | grep mariadb|xargs rpm -e

2、安装MySQL

mkdir -p /data/soft && cd /data/soft
 
wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
 
rpm -ivh mysql-community-release-el7-5.noarch.rpm
 
yum install -y mysql-server
 
rpm -qa | grep mysql
 
mysql -V
 
systemctl enable mysqld.service
 
systemctl start mysqld.service
 
systemctl status mysqld

3、设置MySQL密码

mysql
 
SET PASSWORD FOR root@localhost=PASSWORD('ddmddm123');
flush privileges;
quit
 
mysql -u root -pddmddm123

4、设置mysql允许远程连接

update user set password=password("ddmddm123") where user="root";
#删除空账号用户
delete from mysql.user where user='';
flush privileges;

5、mysql服务启停

###########启动###########
systemctl start mysqld.service
 
###########关闭###########
systemctl stop mysqld.service