centos6.5上安装5.7版本的mysql

2023-11-12 来源：哗拓教育

https://www.cnblogs.com/lzj0218/p/5724446.html

设置root可以在本机以外的机器访问

mysql -uroot -ppassword

> use mysql> select host , user from user;> update user set host = ‘%‘ where user = ‘root‘;> select host , user from user;

搜权 myuser 用户可以用mypassword，从指定ip访问所有的库中所有表

grant all privileges on *.* to ‘myuser‘@‘192.168.0.1‘ identified by ‘mypassword‘ with grant option

centos6.5上安装5.7版本的mysql

标签：sele 机器 roo htm nbsp with set 指定 date

小编还为您整理了以下内容，可能对您也有帮助：

怎么在CentOS安装mysql

方法/步骤

1.首先，需要有一个centos系统，不管是虚拟机还是直接在电脑上安装。下图就是进入到centos系统下的截图。（界面不比windows差哦）

2.之后，是进入到类始于windows下的控制台页面（如果你是安装的虚拟机那你可以通过putty等工具，直接在windows下类似于远程访问，进入到控制台下）

3.之后，进入到控制台下，输入rpm -qa | grep mysql，检测下是否已经安装了mysql。（可以通过 rpm -e 命令或者 rpm -e --nodeps 进行卸载，在删除完以后我们可以通过 rpm -qa | grep mysql 命令来查看mysql是否已经卸载成功）

4.之后，在控制台下输入“yum install -y mysql-server mysql mysql-devel ”，回测，进行安装。

5.之后，就不用管，进入到自动下载，之后再进入到解包的过程（下图就是解包的提示信息，不用管，解包完成自动进入到安装）

6.最后，当控制台页面出现“complete”页面时，则标明已经安装成功了。

这个时候通过输入“mysql -t root -p”进入到mysql页面，输入密码之后进入。再次输入“use mysql”即可使用mysql了。

centos安装mysql数据库的方法

1、首先下载MySQL的安装文件，我这里安装的是MySQL5.1.7版本的，

2、安装MySQL数据库服务器

进入安装包所在文件夹，执行命令 rpm -ivh MySQL-server-5.1.7-0.i386.rpm 安装MySQL服务器。

如果报了与原先版本冲突的话，就执行rpm -qa|grep -i mysql命令，会显示已安装的Mysql版本,我的显示mysql-libs-5.1.61-4.el6.i686

这时如果有的话就强制删除：rpm -e --nodeps mysql-libs-5.1.61-4.el6.i686（因为有包依赖，所以要强制删除）

我的报错提示如下：

复制代码

代码如下:

MySQL-server-5.1.7-0.i386.rpm

Preparing... ########################################### [100%]

file /usr/share/mysql/charsets/README from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/Index.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/armscii8.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/ascii.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp1250.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp1251.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp1256.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp1257.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp850.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp852.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/cp866.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/dec8.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/geostd8.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/greek.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/hebrew.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/hp8.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/keybcs2.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/koi8r.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/koi8u.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/latin1.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/latin2.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/latin5.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/latin7.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/macce.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/macroman.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/charsets/swe7.xml from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/czech/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/danish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/tch/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/english/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/estonian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/french/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/german/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/greek/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/hungarian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/italian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/japanese/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/korean/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/norwegian-ny/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/norwegian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/polish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/portuguese/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/romanian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/russian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/serbian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/slovak/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/spanish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/swedish/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

file /usr/share/mysql/ukrainian/errmsg.sys from install of MySQL-server-5.1.7-0.i386.rpm conflicts with file from package mysql-libs-5.1.61-4.el6.i686

这时候再执行rpm -ivh MySQL-server-5.1.7-0.i386.rpm安装即可安装成功。

我这里安装成功了，但是mysql服务无法启动，总是启动失败，后来百度了一下，是因为selinux的原因，只要将selinux关闭就OK了。

关闭selinux：vi /etc/selinux/config 将SELINUX=enforcing 改成SELINUX=disabled 然后重启

关闭selinux之后还是无法启动mysql服务，因为安装的mysql所有者是root，在安装mysql的时候会创建一个用户mysql，只要将/var/lib/mysql

的所有者改为mysql就OK了，执行命令chown -R mysql:mysql /var/lib/mysql

现在执行service mysql start终于可以启动mysql服务了。

3.安装MySQL客户端

执行命令rpm -ivh MySQL-client-5.1.7-0.i386.rpm进行安装。

4.安装成功

成功安装MySQL后将sql文件导入到数据库，步骤如下：

进入MYSQL Command Line Client

1、先创建数据库：create database test 注：test是创建数据库的名称

2、再切换到当前数据库：use test

3、再输入：/. /root/test.sql 或 souce /root/test.sql

按照以上步骤就可以将备份的sql脚本导入到linux中的数据库中去。

centos6.5下如何安装mysql 我得去mysql的官网下载安装包。然后我用u盘插到电脑上？

去官网两种安装方式一个是source 一个rpm source 需要你自己安装编译器编译,rpm 直接安装.

centos 6.5 安装mysql怎么快速安装

centos 6.5 安装mysql怎么快速安装
1、新建新的日志文件组，比原来的大小大一些（假如说原来是50M，现在变为100M）
alter database add logfile group 4 ('/u01/oracle/proct/10.0.2/oradata/ORCL/redo41.log') size 100m;
alter database add logfile group 5 ('/u01/oracle/proct/10.0.2/oradata/ORCL/redo51.log') size 100m;
alter database add logfile group 6 ('/u01/oracle/proct/10.0.2/oradata/ORCL/redo61.log') size 100m;
2、切换到新加的日志文件组组，是4、5、6其中的一个变为current，相关状态可查看v$log视图
可使用alter system switch logfile;

centos 6.5 安装mysql怎么快速安装

如何升级CentOS 6.5下的MySQL

1、备份数据库，升级MySQL通常不会丢失数据，但保险起见，我们需要做这一步。输入命令：

mysqlmp -u xxx -h xxx -P 3306 -p --all-databases > databases.sql

2、停止mysql服务，输入命令：
service mysqld stop

3、卸载旧版MySQL，输入命令：
yum remove mysql mysql-*

执行过程中会询问你是否移除，此时输入“Y”

查看已安装的软件：rpm -qa¦grep mysql

卸载mysql：yum remove mysql mysql-server mysql-libs compat-mysql51

4、移除命令执行后，可再看看是否有残余的mysql，输入命令：
yum list installed | grep mysql

如果有，可输入命令删除：

yum remove mysql－libs

5、下载安装最新的rpm文件。
这步要看你需要什么文件，我安装的是：mysql57-community-release-el6-7.noarch.rpm（如果提前得到了这个文件，第6步可以使用yum localinstall
mysql57-community-release-el6-7.noarch.rpm从本地安装）

rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

6、安装MySQL，输入命令（过程中问询是否yes，一路y下去）：
yum install mysql-community-server

7、安装完成后，输入命令查看MySQL版本号：
mysql -V

8 、启动MySQL，输入命令：
service mysqld start

第一次启动比较慢，因为它会自己做初始化，耐心等待即可。
如果启动失败，提示“MySQL Daemon failed to start”，可以尝试先初始化mysql，输入命令：mysqld --initialize。
如果初始化提示：
2015-12-22T07:49:45.386095Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-22T07:49:45.388125Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2015-12-22T07:49:45.388153Z 0 [ERROR] Aborting
说明数据文件夹已被创建，直接删除，让mysql自己创建即可，输入命令：rm -rf /var/lib/mysql
删除后，注意：然后不需要再初始化了，直接启动mysql，它会自己初始化，输入命令：
service mysqld start

9、进入mysql后，第一件事件就是要你改默认密码。mysql 5.7以后，系统自动生成随机的密码，我操作时，没登录上，切换mysql到安全模式启动，自己去修改即可(安全模式修改密码，见另一篇文章：MySQL忘记密码，或：root密码重置报错：mysqladmin: connect to server at 'localhost' failed的解决方案)。

[root@c12 mysql57]# ./bin/mysql -u root -p

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> alter user root identified by 'root';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

使用mysqladmin总算能改了
[root@c12 mysql57]# ./bin/mysqladmin -u root -p password
Enter password:
New password:
Confirm new password:
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.8-rc |
+-----------+
1 row in set (0.00 sec)

10、设置mysql为开机启动

chkconfig --list 显示服务列表

如果看到mysqld的服务，并且3,4,5都是on的话则成功，如果是off，则键入

chkconfig --level 345 mysqld on
reboot重启电脑
netstat -na | grep 3306，如果看到有监听说明服务启动了。也可以用：service mysqld status看状态

如何升级CentOS 6.5下的MySQL

备份数据库，升级MySQL通常不会丢失数据，但保险起见，我们需要做这一步。输入命令：

mysqlmp -u xxx -h xxx -P 3306 -p --all-databases > databases.sql

停止MySQL服务，输入命令：

service mysqld stop

卸载旧版MySQL，输入命令：

yum remove mysql mysql-*

执行过程中会询问你是否移除，此时输入“Y”

移除命令执行后，可再看看是否有残余的mysql，输入命令：

yum list installed | grep mysql

如果有，可输入命令删除：

rum remove mysql－libs

下载安装最新的rpm文件

rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm

安装MySQL，输入命令：

yum install mysql-community-server

7.安装完成后，输入命令查看MySQL版本号：

mysql -V

8.启动MySQL，输入命令：

service mysqld start

如何在centos安装mysql时自主选择版本

首先选择正确的云yum源

MYSQL的yum源在官网

以下以centos7和centos8为例

下载源

安装源（这个源里面有8.0和5.7,两个版本，下一篇会介绍如何增加其他版本）

查看当前可安装的mysql版本

以上源默认是8.0版本的

需要8.0可以直接运行安装（更换5.7略过此步骤）

查看库中所有版本

如果我们要选择版本，可以先执行下面命令查看一下有哪些版本

查看输出

安装开启和禁用仓库的命令

开启5.7禁用8.0

这样我们就开启了5.7关闭了8.0

再次查看

为了保险我们可以再次用命令查看以下

输出结果

5.7已启用

开始安装5.7

启动

如何在centos安装mysql时自主选择版本

首先选择正确的云yum源

MYSQL的yum源在官网

以下以centos7和centos8为例

下载源

安装源（这个源里面有8.0和5.7,两个版本，下一篇会介绍如何增加其他版本）

查看当前可安装的mysql版本

以上源默认是8.0版本的

需要8.0可以直接运行安装（更换5.7略过此步骤）

查看库中所有版本

如果我们要选择版本，可以先执行下面命令查看一下有哪些版本

查看输出

安装开启和禁用仓库的命令

开启5.7禁用8.0

这样我们就开启了5.7关闭了8.0

再次查看

为了保险我们可以再次用命令查看以下

输出结果

5.7已启用

开始安装5.7

启动

centos6.5安装mysql，是否要将mysql-server，mysql-client,mysql-shared,mysql-devel都安装？

如果是rpm包...只需要安装mysql-server,mysql-client 如果采用cmake编译安装..那是一个tar.gz的压缩包..你确定你是不是下载正确的包了...一边编译包有config.cmake,cmakelist.txt,configure.cmake等类似文件就是编译安装包..大小跟你说的差不多..在50m左右....

如果是rpm安装包...会更大..因为没有压缩...大概server在80m左右...client在20m左右....

另外.虽然先在有5.7的版本了..但大家在线上环境都是采用更稳定的5.6.x版本...追问谢谢了！我用cmake2.8.6，可是怎么也装不上，不知为什么。有qq吗？我需要您的帮助

追答cmake本身就是需要编译的...你有编译么? 如果安装或者编译有问题..看提示..很可能是缺少某些依赖包...

Centos6.5源码安装Mysql，make报错

错误原因是少gcc-c++这个包

解决办法：yum install gcc-c++

再次执行make 可能还会报错。

是因为gcc-c++是在configure之后安装的，此时只需重新./configure上一步的安装然后再编译make即可。这里就可以顺利的通过

显示全文

全部栏目

centos6.5上安装5.7版本的mysql