centos安装mysql

检查环境

 rpm -qa | grep mariadb

强制卸载,因为与mysql依赖冲突

安装程序

• 安装mysql-community-common-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm

• 安装mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm

 rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm

• 安装mysql-community-libs-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm

• 安装mysql-community-client-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.32-1.el7.x86_64.rpm 

• 安装mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm

rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm

• 安装mysql-community-server-8.0.32-1.el7.x86_64.rpm

 rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm 

初始化数据库

 mysqld --initialize --console

初始化失败安装补充的环境

sudo yum install libstdc++.so.6
sudo yum install libc.so.6

成功结果

赋予权限

chown -R mysql:mysql /var/lib/mysql/

设置开机自启动

sudo systemctl enable mysqld

连接数据库

• 查看密码

• 连接数据库

mysql -uroot -p

• 更改数据库密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

• 刷新权限

FLUSH PRIVILEGES;

• 开启远程访问

use mysql;
# 我还以为0.0.0.0没想到是%才是指的全部
update user set host='%' where host='localhost';
flush privileges;