Linux安装MySql最新版

1. MySql下载、解压、上传(/opt/mysql)
   https://dev.mysql.com/downloads/mysql
   
   

2. MySql旧版本(卸载)

   rpm -e --nodeps `rpm -qa | grep -i mysql` && rm -rf /var/lib/mysql /etc/my.cnf.rpmsave /var/log/mysqld.log

   

3. MySql新版本(安装)

   yum install openssl-devel && rpm -ivh --force --nodeps /opt/mysql/*.rpm

   

4. MySql登录

   启动服务：systemctl start mysqld
   重启服务：systemctl restart mysqld
   关闭服务：systemctl stop mysqld
   临时密码：cat /var/log/mysqld.log
   登录root：mysql -u root -p

   

5. MySql改密码

   1.变更密码策略
   ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abc@123456';
   set global validate_password.policy = 0;
   set global validate_password.length = 6;
   
   2.修改root密码
   ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
   
   3.创建新用户
   create user '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
   
   4.授权新用户
   grant all on *.* to '用户名'@'%';
   
   5.删除新用户
   drop user '用户名'@'%';

   

6. MySql连接

   防火墙打开端口权限：firewall-cmd --zone=public --add-port=3306/tcp --permanent && firewall-cmd --reload