1、centos7默认安装了Mariadb,为了避免冲突,所以要先删除
先查询 rpm -qa | grep mariadb
卸载
rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64
错误:依赖检测失败:
libmysqlclient.so.18()(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86_64 需要
libmysqlclient.so.18(libmysqlclient_18)(64bit) 被 (已安裝) postfix-2:2.10.1-6.el7.x86_64 需要
#强制卸载,因为没有--nodeps
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64
2、进入/tmp目录下下载mysql rpm包
cd /tmp
wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
3、本地安装
yum localinstall -y mysql80-community-release-el7-2.noarch.rpm
yum install –y mysql-community-server
4、启动mysql,并连接mysql
sudo service mysqld start
ps -ef | grep mysqld
查看临时密码,并登录,如下图
cat /var/log/mysqld.log | grep password #找出临时密码
mysql -uroot -p你的密码
5、修改密码
查看数据库的时候会报错:这里提示我们必须重置密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
以上操作后又遇到新问题:
ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements
可以修改密码规则
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password.length =6;
Query OK, 0 rows affected (0.07 sec)
刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
然后退出重新登录
6、设置远程登录
Update user set host='%' where host="localhost" and user="root";
Flush privileges;#获取退出去重启mysql服务
如果之后用navicate连接出现错误,请访问以下博客