mysql5.6与5.7差别_mysql5.7和mysql5.6同在CentOS7.4安装差异对比之5.7.18

Mysql5.7.18

rpm -qa|grep mariadb // 查询出来已安装的mariadb

rpm -e --nodeps 文件名 // 卸载mariadb，文件名为上述命令查询出来的文件

yum install libaio

groupadd mysql

useradd -r -g mysql -s /bin/false mysql

tar zxvf /path/to/mysql-VERSION-OS.tar.gz

mv mysql-VERSION-OS /usr/local/

ln -s full-path-to-mysql-VERSION-OS mysql

cd /usr/local/mysql

mkdir mysql-files

chown mysql:mysql mysql-files

chmod 750 mysql-files

cd /data/

chown mysql.mysql mysql/ -R

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data

bin/mysql_ssl_rsa_setup

bin/mysqld_safe --user=mysql &

cp support-files/mysql.server /etc/init.d/mysqld

echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

source /etc/profile

MySQL> set password='xxxxx';  修改密码

MySQL> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; 设置密码不过期

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