下载centos镜像

http://mirrors.163.com/centos/7.9.2009/isos/x86_64/
cd /etc/sysconfig/newwork-scripts 编辑网卡配置文件 开启网络

  1. BOOTPROTO=static
  2. IPADDR=192.168.50.218
  3. GATEWAY=192.168.50.1
  4. NETMASK=255.255.255.0
  5. DNS1=192.168.50.1
  6. ONBOOT=yes

用shell终端 ssh登录
开放3306端口的远程访问权限：firewall-cmd —zone=public —add-port=3306/tcp —permanent
刷新防火墙规则： firewall-cmd —reload

清理旧数据库

rpm -pa | grep mysql
依次yum remove mysql-xxx-xxx-
find / -name mysql
rm -rf /var/lib/mysql

rpm -pa | grep mariadb
rpm -e mariadb-libs-5.5.56-2.el7.x86_64

yum安装mysql

  1. 到网址https://dev.mysql.com/downloads/repo/yum/查询最新对应centos版本的rpm
  2. yum下载MySQL的安装配置：sudo yum localinstall https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

  3. yum安装MySQL：sudo yum install mysql-community-server

    配置mysql

  4. 启动MySQL服务：sudo service mysqld start

  5. 查看初始密码（如无内容直接跳过）：sudo grep ‘password’ /var/log/mysqld.log
  6. 登录mysql用户：mysql -uroot -p
  7. 修改密码：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '包含大小写字母及数字的密码'
  8. 开启非本地主机访问：use mysql; update user set host=’%’ where user=’root’;
  9. 给用户授权：GRANT ALL PRIVILEGES ON . TO ‘root’@’%’WITH GRANT OPTION;FLUSH PRIVILEGES;

    mysql排错

    cat /var/log/mysql.log 查看mysql的错误日志