Centos6.8下载和配置MySQL5.7

左手的ㄟ右手 2022-01-29 02:51 126阅读 0赞

因为要小组联合开发，公用服务器的数据库，但之前的数据库安装的是MySQL8.0版本,经过考虑还是卸载安装成MySQL5.7，接下来就讲解 Centos6.8下载和配置MySQL5.7 的入坑填坑之路。

## 1，卸载系统内之前安装的MySQL(没安装过的跳过) ##

转载：[https://www.jianshu.com/p/5fa0cbe16bd7][https_www.jianshu.com_p_5fa0cbe16bd7]  
这篇文章是讲解彻底删除MySQL。

## 2，安装MySQL5.7 ##

#### 下载mysql安装包 ####

> wget  
> [https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.22-1.el6.x86\_64.rpm][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-server-5.7.22-1.el6.x86_64.rpm]  
> wget  
> [https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.22-1.el6.x86\_64.rpm][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-common-5.7.22-1.el6.x86_64.rpm]  
> wget  
> [https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.22-1.el6.x86\_64.rpm][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-libs-5.7.22-1.el6.x86_64.rpm]  
> wget  
> [https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.22-1.el6.x86\_64.rpm][https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-client-5.7.22-1.el6.x86_64.rpm]

#### 开始安装安装顺序common -> libs -> client -> server ####

> rpm -ivh mysql-community-common-5.7.22-1.el6.x86\_64.rpm
> 
> rpm -ivh mysql-community-libs-5.7.22-1.el6.x86\_64.rpm
> 
> rpm -ivh mysql-community-client-5.7.22-1.el6.x86\_64.rpm
> 
> rpm -ivh mysql-community-server-5.7.22-1.el6.x86\_64.rpm

#### 启动mysql服务 ####

service mysqld start  
或  
/etc/init.d/mysql start

#### 查看是否启动 ####

ps -ef | grep mysql  
netstat -nat | grep 3306  
netstat -ntlp | grep mysqld

#### 获取临时密码 ####

cat /var/log/mysqld.log | grep ‘temporary password’;

#### 登录数据库 ####

mysql -u root -p;（分号表示结束符）

#### 修改密码 ####

set password=password(“新密码”);

#### 退出数据库 ####

mysql exit;

#### 设置数据库开机启动（防止服务器重启后导致数据库不启动） ####

使用命令chkconfig设置开机启动，将mysqld 放入linux启动管理体系中

chkconfig --add mysqld  
转载：[centos6.7设置开机自启动][centos6.7]

## 后序-mysql开启远程访问权限 ##

目的：小组所有成员使用同一数据库，方便。

//登录数据库
    　　mysql -u root -pvmwaremysql>use mysql; 
    　　//%为所有ip都可以远程访问
    　　mysql>update user set host = '%' where user = 'root';  
       //或直接添加一条语句也行   　　
       mysql>insert into user (host,user,password) values('192.168.0.51','root',password('123'));　　
    　　//查看一下修改
    　  mysql>select host, user from user;    
       //推送设置到内存或重启服务器也行
    　　mysql>FLUSH PRIVILEGES ;

[https_www.jianshu.com_p_5fa0cbe16bd7]: https://www.jianshu.com/p/5fa0cbe16bd7
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-server-5.7.22-1.el6.x86_64.rpm]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.22-1.el6.x86_64.rpm
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-common-5.7.22-1.el6.x86_64.rpm]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.22-1.el6.x86_64.rpm
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-libs-5.7.22-1.el6.x86_64.rpm]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.22-1.el6.x86_64.rpm
[https_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-community-client-5.7.22-1.el6.x86_64.rpm]: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.22-1.el6.x86_64.rpm
[centos6.7]: https://blog.csdn.net/qq_33468857/article/details/82023830