1.先卸载Linux自带的mysql
yum -y remove mysql-libs
2.安装mysql服务端,根据提示安装需要对应的依赖
rpm -ivh MySQL-server-5.6.50-1.el7.x86_64.rpm
3.安装对应的依赖
yum -y install perl*
4. 重新安装mysql服务端,根据提示删除对应的冲突包
rpm -ivh MySQL-server-5.6.50-1.el7.x86_64.rpm
5.删除对应的冲突包
yum -y remove mariadb-libs-1:5.5.68-1.el7.x86_64
6.重新安装mysql服务端,安装成功
rpm -ivh MySQL-server-5.6.50-1.el7.x86_64.rpm
7.安装mysql客户端
rpm -ivh MySQL-client-5.1.73-1.glibc23.x86_64.rpm
8.在命令行输入mysql进入数据库
9.设置数据库的账号和密码
set password for 'root'@'localhost'=password('123456');
刷新:flush privileges;
10.授权mysql远程登录(这里设置物理机就可以通过navicat远程访问登录虚拟机的mysql)
注意哦,要关闭虚拟机的防火墙(systemctl stop firewalld)
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
刷新:flush privileges;
11.退出数据库
exit
12.重新使用账号密码登录
mysql -uroot -p123456