数据库教程:linux环境下安装mysql8.0过程介绍

目录

• 前言
• 一、linux更改yum源(如果mysql安装慢可以试)
• 二、版本
• 三、安装
• 四、查看临时密码
• 五、配置外网可以访问
• 六、测试
• 七、 数据库卸载
• 八、 问题
• 总结

  cd /etc/yum.repos.d/  

  mv centos-base.repo centos-base-yum.repo  

  wget https://mirrors.163.com/.help/centos6-base-163.repo

  mv centos6-base-163.repo centos-base.repo

  yum update

  wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

  wget https://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

   sudo rpm -ivh mysql80-community-release-el7-3.noarch.rpm

  sudo rpm -ivh mysql5.7-community-release-el7-8.noarch.rpm

  sudo yum install mysql-server

  systemctl restart mysqld

  grep "a temporary password" /var/log/mysqld.log

  mysql -u root -p

  set global validate_password.length=4;

  set global validate_password.policy=0;

  set global validate_password.check_user_name=off;

  alter user 'root'@'localhost' identified by '新密码';

  exit

  mysql -u root -p

  use mysql;

  update user set host='%' where user='root';

  flush privileges;

  exit

  systemctl restart mysqld

  rpm -qa | grep -i mysql

  yum remove 名字大全

  rm -rf /var/lib/mysql

  alter user 'root'@'localhost' identified by '生成密码';

  set global validate_password.length=4;

  set global validate_password.policy=0;

  alter user 'root'@'localhost' identified by '新密码';