本机安装mysql还是虚拟机_虚拟机安装mysql

a.下载mysql压缩包(对应自己版本)&＃xff0c;通过xshell上传到虚拟机

b.删除原有的mariadb(下面是例句),如果安装过mysql也要删除

(1)查询&＃xff1a;rpm -qa | grep mariadb

(2)卸载mariadb&＃xff1a;rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

c. (1)检查安装libaio环境&＃xff1a;

rpm -qa|grep libaio

(2)没有则安装&＃xff0c;上传后安装命令&＃xff1a;

rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm

d&＃xff0e;解压mysql安装包

(1)安装mysql-community-common-5.7.27-1.el7.x86_64.rpm

rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm --force --nodeps

(2)安装mysql-community-libs-5.7.27-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm --force --nodeps

(3)安装mysql-community-devel-5.7.27-1.el7.x86_64.rpm

rpm -ivh mysql-community-devel-5.7.27-1.el7.x86_64.rpm --force --nodeps

(4)安装mysql-community-libs-compat-5.7.27-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-5.7.27-1.el7.x86_64.rpm --force --nodeps

(5)安装mysql-community-client-5.7.27-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm --force --nodeps

(6)安装mysql-community-server-5.7.27-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm --force --nodeps

e&＃xff0e;关闭mysql

systemctl stop mysqld.service

f&＃xff0e;修改配置文件

vim /etc/my.cnf

g&＃xff0e;设置免密码登录&＃xff1a;在mysqld标签内添加skip-grant-tables

h&＃xff0e;修改/var/lib/mysql权限

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

i&＃xff0e; 启动服务&＃xff0c;空密码登录

systemctl start mysqld.service

mysql -u root

j&＃xff0e;修改密码

flush privileges; // 更新权限

set password for root&＃64;localhost &＃61; password(&＃39;123456&＃39;); // 设置root密码为123456;

use mysql;

update user set host &＃61; &＃39;%&＃39; where user &＃61;&＃39;root&＃39;; //配置可远程登录

flush privileges; //更新权限

exit; //退出

k&＃xff0e;设置自启(可以不设置)

systemctl enable mysqld