1,更新yun
yum -y update:升级所有包同时也升级软件和系统内核
yum -y upgrade:只升级所有包,不升级软件和系统内核
2 ,卸载mariadb虚拟机自带的数据库,否则安装MySql会出现冲突
rpm -qa|grep mariadb
rpm -e --nodeps 文件名
3,如果没有wget(下载工具)命令:yum install wget
4,创建文件夹:/opt/mysql
5,查看是否安装了mysql:yum list installed | grep mysql
查看安装的rpm:rpm -qa | grep *
删除rpm: rpm -e 名称
6,下载5.7版本
wget http://repo.mysql.com/mysql57-community-release-el7.rpm
rpm -ivh mysql57-community-release-el7.rpm
7,下载安装mysql
yum install mysql-server
8,也可以本地下载数据库包上传到linux:yum install lrzsz (rz上传 sz 文件名下载)
9,启动mysql服务:service mysqld start
查看mysql随机密码:grep 'temporary password' /var/log/mysqld.log
10,登入mysql
mysql -u root -p
11,修改root密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Cheng@12345');
12,开机启动mysql:systemctl enable mysqld
13,查询mysql的root用户是否能被远程连接到:localhost只能本地访问,%都可以访问
use mysql;
select host from user where user='root';
修改:update user set host = '%' where user ='root';
14,最后看下进程
ps -ef | grep mysql
15,停用/永久关闭防火墙:
systemctl stop firewalld
systemctl disable firewalld
查看防火墙状态:systemctl status firewalld