1：centos安装mysql5.7-8

下载：

上传到服务器后修改权限：

解压：

代码：tar -xvf mysql-5.7.36-1.el7.x86_64.rpm-bundle.tar
修改权限：

代码：chmod 777 ./*
安装：

代码：

rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm

·

error: Failed dependencies:
        mariadb-libs is obsoleted by mysql-community-libs-8.0.29-1.el7.x86_64
解决：yum remove mysql-libs

查看是否启动：
systemctl restart mysqld.service
service mysql status | systemctl start mysqld

启动：service mysqld start | systemctl status mysqld
查看临时密码：grep password /var/log/mysqld.log

登录：mysql -uroot -p -回车-> 输入临时密码
修改密码：set password = password(“密码”);
如果执行错误则使用：alter user user() identified by “123456”;
切换数据库到mysql：use mysql;
查看数据库用户：select user,host from user
修改权限：update user set host=’%’ where user=’root’;
用户权限刷新：flush privileges；
放开3306防火墙：firewall-cmd —zone=public —permanent —add-port=3306/tcp
防火墙重新加载：firewall-cmd —reload

common→libs→client→server