centos 6.5 yum安装mysql5.6（重要）

最新推荐文章于 2024-08-29 00:30:00 发布

琅琊山二当家

最新推荐文章于 2024-08-29 00:30:00 发布

阅读量614

点赞数

分类专栏： mysql

mysql 专栏收录该内容

79 篇文章

订阅专栏

本文介绍了如何在 CentOS 6.5 上通过 YUM 源安装 MySQL 5.6 的详细步骤，包括导入 MySQL 版本库、安装相应的类库、启动数据库服务及配置 root 用户密码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查看当前的mysql yum源

[admin@AS104 home]$ yum list | grep mysql
mysql-libs.x86_64 5.1.73-8.el6_8 @anaconda-CentOS-201703281317.x86_64/6.9
apr-util-mysql.x86_64 1.3.9-3.el6_0.1 base
bacula-director-mysql.x86_64 5.0.0-13.el6 base
bacula-storage-mysql.x86_64 5.0.0-13.el6 base
dovecot-mysql.x86_64 1:2.0.9-22.el6 base
freeradius-mysql.x86_64 2.2.6-6.el6_7 base
libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 base
mod_auth_mysql.x86_64 1:3.0.0-11.el6_0.1 base
mysql.x86_64 5.1.73-8.el6_8 base
mysql-bench.x86_64 5.1.73-8.el6_8 base
mysql-connector-java.noarch 1:5.1.17-6.el6 base
mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 base
mysql-devel.i686 5.1.73-8.el6_8 base
mysql-devel.x86_64 5.1.73-8.el6_8 base
mysql-embedded.i686 5.1.73-8.el6_8 base
mysql-embedded.x86_64 5.1.73-8.el6_8 base
mysql-embedded-devel.i686 5.1.73-8.el6_8 base
mysql-embedded-devel.x86_64 5.1.73-8.el6_8 base
mysql-libs.i686 5.1.73-8.el6_8 base
mysql-server.x86_64 5.1.73-8.el6_8 base
mysql-test.x86_64 5.1.73-8.el6_8 base
pcp-pmda-mysql.x86_64 3.10.9-9.el6 base
php-mysql.x86_64 5.3.3-49.el6 base
qt-mysql.i686 1:4.6.2-28.el6_5 base
qt-mysql.x86_64 1:4.6.2-28.el6_5 base
rsyslog-mysql.x86_64 5.8.10-10.el6_6 base
rsyslog7-mysql.x86_64 7.4.10-7.el6 base
[admin@AS104 home]$ pwd

引入mysql 5.6的yum的数据源

[admin@AS104 home]$ wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
--2017-06-20 14:47:47-- http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Resolving repo.mysql.com... 69.192.245.30
Connecting to repo.mysql.com|69.192.245.30|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5824 (5.7K) [application/x-redhat-package-manager]
mysql-community-release-el6-5.noarch.rpm: Permission denied

Cannot write to “mysql-community-release-el6-5.noarch.rpm” (Permission denied).
[admin@AS104 home]$ sudo wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
--2017-06-20 14:47:54-- http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
Resolving repo.mysql.com... 69.192.245.30
Connecting to repo.mysql.com|69.192.245.30|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5824 (5.7K) [application/x-redhat-package-manager]
Saving to: “mysql-community-release-el6-5.noarch.rpm”

100%[=====================================================================>] 5,824 --.-K/s in 0s

2017-06-20 14:47:55 (50.8 MB/s) - “mysql-community-release-el6-5.noarch.rpm” saved [5824/5824]

[admin@AS104 home]$ rpm -ivh mysql-community-release-el6-5.noarch.rpm
error: can't create transaction lock on /var/lib/rpm/.rpm.lock (Permission denied)
[admin@AS104 home]$ sudo rpm -ivh mysql-community-release-el6-5.noarch.rpm
Preparing... ########################################### [100%]
1:mysql-community-release########################################### [100%]
[admin@AS104 home]$ yum list | grep mysql
mysql-community-release.noarch el6-5 installed
apr-util-mysql.x86_64 1.3.9-3.el6_0.1 base
bacula-director-mysql.x86_64 5.0.0-13.el6 base
bacula-storage-mysql.x86_64 5.0.0-13.el6 base
dovecot-mysql.x86_64 1:2.0.9-22.el6 base
freeradius-mysql.x86_64 2.2.6-6.el6_7 base
libdbi-dbd-mysql.x86_64 0.8.3-5.1.el6 base
mod_auth_mysql.x86_64 1:3.0.0-11.el6_0.1 base
mysql.x86_64 5.1.73-8.el6_8 base
mysql-bench.x86_64 5.1.73-8.el6_8 base
mysql-community-bench.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-client.i686 5.6.36-2.el6 mysql56-community
mysql-community-client.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-common.i686 5.6.36-2.el6 mysql56-community
mysql-community-common.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-devel.i686 5.6.36-2.el6 mysql56-community
mysql-community-devel.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-embedded.i686 5.6.36-2.el6 mysql56-community
mysql-community-embedded.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-embedded-devel.i686 5.6.36-2.el6 mysql56-community
mysql-community-embedded-devel.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-libs.i686 5.6.36-2.el6 mysql56-community
mysql-community-libs.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-libs-compat.i686 5.6.36-2.el6 mysql56-community
mysql-community-libs-compat.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-server.x86_64 5.6.36-2.el6 mysql56-community
mysql-community-test.x86_64 5.6.36-2.el6 mysql56-community
mysql-connector-java.noarch 1:5.1.17-6.el6 base
mysql-connector-odbc.x86_64 5.3.8-1.el6 mysql-connectors-community
mysql-connector-odbc-debuginfo.x86_64 5.3.8-1.el6 mysql-connectors-community
mysql-connector-odbc-setup.x86_64 5.3.8-1.el6 mysql-connectors-community
mysql-connector-python.noarch 2.0.4-1.el6 mysql-connectors-community
mysql-connector-python.x86_64 2.1.6-1.el6 mysql-connectors-community
mysql-connector-python-cext.x86_64 2.1.6-1.el6 mysql-connectors-community
mysql-connector-python-debuginfo.x86_64 2.1.6-1.el6 mysql-connectors-community
mysql-devel.i686 5.1.73-8.el6_8 base
mysql-devel.x86_64 5.1.73-8.el6_8 base
mysql-embedded.i686 5.1.73-8.el6_8 base
mysql-embedded.x86_64 5.1.73-8.el6_8 base
mysql-embedded-devel.i686 5.1.73-8.el6_8 base
mysql-embedded-devel.x86_64 5.1.73-8.el6_8 base
mysql-libs.i686 5.1.73-8.el6_8 base
mysql-libs.x86_64 5.1.73-8.el6_8 base
mysql-ref-manual-5.6-en-html-chapter.noarch 1-20170318 mysql56-community
mysql-ref-manual-5.6-en-pdf.noarch 1-20170318 mysql56-community
mysql-router.x86_64 2.1.3-1.el6 mysql-tools-community
mysql-router-debuginfo.x86_64 2.1.3-1.el6 mysql-tools-community
mysql-server.x86_64 5.1.73-8.el6_8 base
mysql-shell.x86_64 1.0.9-1.el6 mysql-tools-community
mysql-shell-debuginfo.x86_64 1.0.9-1.el6 mysql-tools-community
mysql-test.x86_64 5.1.73-8.el6_8 base
mysql-utilities.noarch 1.6.5-1.el6 mysql-tools-community
mysql-utilities-extra.noarch 1.5.6-1.el6 mysql-tools-community
mysql-workbench-community.x86_64 6.3.8-1.el6 mysql-tools-community
mysql-workbench-community-debuginfo.x86_64 6.3.8-1.el6 mysql-tools-community
pcp-pmda-mysql.x86_64 3.10.9-9.el6 base
php-mysql.x86_64 5.3.3-49.el6 base
qt-mysql.i686 1:4.6.2-28.el6_5 base
qt-mysql.x86_64 1:4.6.2-28.el6_5 base
rsyslog-mysql.x86_64 5.8.10-10.el6_6 base
rsyslog7-mysql.x86_64 7.4.10-7.el6 base
[admin@AS104 home]$

参考

centos 6.5 yum安装mysql5.6

http://2860664.blog.51cto.com/2850664/1553642/

1、删除系统自带的mysql

rpm -qa|grep mysql

yum remove mysql-libs

2、安装mysql YUM源

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

rpm -ivh mysql-community-release-el6-5.noarch.rpm

3、安装mysql

yum install mysql-server mysql-devel

4、root密码设置

service mysqld stop

mysqld_safe --skip-grant-tables & mysql -u root -p // 回车直接进去，或者随便输入一个密码

use mysql;

update user set password=PASSWORD("newpass")where user="root"; 更改密码为 newpassord

flush privileges; 更新权限

quit

这里可能遇到

修改mysql数据库时候

show database 没有mysql数据库解决办法

将另外一个数据库的mysql库脚本拷贝到新装的服务器上（脚本sql 直接create 逐条）即可

http://blog.youkuaiyun.com/mycms5/article/details/52825617

或者参考:

centos6.5用yum安装mysql5.6方法

第一步：导入mysql版本库

yum install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

第二步：安装mysql相应类库

yum install mysql mysql-devel mysql-server mysql-utilities

第三步：启动数据库

/etc/init.d/mysqld start

第四步：登录 mysql数据

mysql -uroot -p

第五步：修改MySQL的root用户的密码以及打开远程连接

mysql> use mysql;

mysql> desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力
mysql> update user set Password = password('123456') where User='root'; //设置root用户密码
mysql> select Host,User,Password from user where User='root';
mysql> flush privileges;

mysql> exit