- 先检查下mysql是否已经安装过
[root@localhost ~]# rpm -qa | grep mysql [root@localhost ~]# rpm -qa |grep mariadb 我这里要卸载mariadb [root@localhost ~]# yum remove mariadb-libs-5.5.64-1.el7.x86_64
- 下载阿里云yum源配置
# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo # yum makecache # yum update -y 安装依赖 yum install -y perl.x86_64 libaio.x86_64 net-tools.x86_64
- 下载国内的mysql rpm包并安装
也可也选择清华源
https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-5.7-community-el7-x86_64/
先是server包 [root@localhost ~]# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-server-5.7.25-1.el7.x86_64.rpm 然后是client包 wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-client-5.7.25-1.el7.x86_64.rpm 还有common [root@localhost ~]# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-common-5.7.25-1.el7.x86_64.rpm 最后还有一个lib [root@localhost ~]# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-libs-5.7.25-1.el7.x86_64.rpm
安装mysql
然后按照顺序安装mysql的依赖 [root@localhost ~]# rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm [root@localhost ~]# rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm [root@localhost ~]# rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm [root@localhost ~]# rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
- 重启下mysql服务
# service mysqld.service restart
或者
# systemctl mysqld restart
查看下默认密码
[root@localhost etc]# grep 'temporary password' /var/log/mysqld.log
改下密码和远程连接
# mysql -u root -p
mysql> set password=password('这里输入你想改的密码');
Query OK, 0 rows affected, 1 warning (0.00 sec)
密码需要包含数字和特殊符号，以及大写字母和小写字母
当然你设置完成以后可以就将密码限制关闭后在重新改密码，这里不过多演示
开启远程连接
打开mysql数据库
mysql> use mysql;
修改一条数据使其支持远程连接
mysql> update user set Host = '%' where Host = 'localhost' and User='root';
刷新系统权限相关表
mysql> flush privileges;
