CentOS 6.5安装MySQL

最新推荐文章于 2023-07-05 18:05:49 发布
最新推荐文章于 2023-07-05 18:05:49 发布
阅读量410 收藏
点赞数
分类专栏： Linux 文章标签： mysql centos yum
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u014034685/article/details/54318187
版权

  • 问题描述
    需要在新装的虚拟机上（CentOS 6.5）安装MySQL

  • 解决方法

Step 1: yum list mysql-server + Enter(回车)       //查看yum源中MySQL
Step 2: yum install mysql-server + Enter（回车）    //安装
Step 3: service mysqld start + Enter（回车）        //启动MySQL服务
Step 4: mysql + Enter（回车）       //进入MySQL
  • 过程如下
[root@ldx ~]# yum list mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.cqu.edu.cn
 * extras: mirrors.cqu.edu.cn
 * updates: mirrors.cqu.edu.cn
base                                                     | 3.7 kB     00:00     
extras                                                   | 3.3 kB     00:00     
updates                                                  | 3.4 kB     00:00     
Available Packages
mysql-server.i686                       5.1.73-7.el6                        base
[root@ldx ~]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.cqu.edu.cn
 * extras: mirrors.cqu.edu.cn
 * updates: mirrors.cqu.edu.cn
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-server.i686 0:5.1.73-7.el6 will be installed
--> Processing Dependency: mysql = 5.1.73-7.el6 for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(vars) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(strict) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(Sys::Hostname) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(POSIX) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(Getopt::Long) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(File::Temp) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(File::Path) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(File::Copy) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(File::Basename) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(Data::Dumper) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.73-7.el6.i686
--> Processing Dependency: /usr/bin/perl for package: mysql-server-5.1.73-7.el6.i686
--> Running transaction check
---> Package mysql.i686 0:5.1.73-7.el6 will be installed
--> Processing Dependency: mysql-libs = 5.1.73-7.el6 for package: mysql-5.1.73-7.el6.i686
---> Package perl.i686 4:5.10.1-141.el6_7.1 will be installed
--> Processing Dependency: perl-libs = 4:5.10.1-141.el6_7.1 for package: 4:perl-5.10.1-141.el6_7.1.i686
--> Processing Dependency: perl-libs for package: 4:perl-5.10.1-141.el6_7.1.i686
--> Processing Dependency: perl(version) for package: 4:perl-5.10.1-141.el6_7.1.i686
--> Processing Dependency: perl(Pod::Simple) for package: 4:perl-5.10.1-141.el6_7.1.i686
--> Processing Dependency: perl(Module::Pluggable) for package: 4:perl-5.10.1-141.el6_7.1.i686
--> Processing Dependency: libperl.so for package: 4:perl-5.10.1-141.el6_7.1.i686
---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be installed
---> Package perl-DBI.i686 0:1.609-4.el6 will be installed
--> Running transaction check
---> Package mysql-libs.i686 0:5.1.71-1.el6 will be updated
---> Package mysql-libs.i686 0:5.1.73-7.el6 will be an update
---> Package perl-Module-Pluggable.i686 1:3.90-141.el6_7.1 will be installed
---> Package perl-Pod-Simple.i686 1:3.13-141.el6_7.1 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.13-141.el6_7.1.i686
---> Package perl-libs.i686 4:5.10.1-141.el6_7.1 will be installed
---> Package perl-version.i686 3:0.77-141.el6_7.1 will be installed
--> Running transaction check
---> Package perl-Pod-Escapes.i686 1:1.04-141.el6_7.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                    Arch      Version                   Repository
                                                                           Size
================================================================================
Installing:
 mysql-server               i686      5.1.73-7.el6              base      8.8 M
Installing for dependencies:
 mysql                      i686      5.1.73-7.el6              base      904 k
 perl                       i686      4:5.10.1-141.el6_7.1      base      9.7 M
 perl-DBD-MySQL             i686      4.013-3.el6               base      134 k
 perl-DBI                   i686      1.609-4.el6               base      705 k
 perl-Module-Pluggable      i686      1:3.90-141.el6_7.1        base       40 k
 perl-Pod-Escapes           i686      1:1.04-141.el6_7.1        base       33 k
 perl-Pod-Simple            i686      1:3.13-141.el6_7.1        base      213 k
 perl-libs                  i686      4:5.10.1-141.el6_7.1      base      594 k
 perl-version               i686      3:0.77-141.el6_7.1        base       52 k
Updating for dependencies:
 mysql-libs                 i686      5.1.73-7.el6              base      1.2 M

Transaction Summary
================================================================================
Install      10 Package(s)
Upgrade       1 Package(s)

Total download size: 22 M
Is this ok [y/N]: y
Downloading Packages:
(1/11): mysql-5.1.73-7.el6.i686.rpm                      | 904 kB     00:00     
(2/11): mysql-libs-5.1.73-7.el6.i686.rpm                 | 1.2 MB     00:00     
(3/11): mysql-server-5.1.73-7.el6.i686.rpm               | 8.8 MB     00:01     
(4/11): perl-5.10.1-141.el6_7.1.i686.rpm                 | 9.7 MB     00:01     
(5/11): perl-DBD-MySQL-4.013-3.el6.i686.rpm              | 134 kB     00:00     
(6/11): perl-DBI-1.609-4.el6.i686.rpm                    | 705 kB     00:00     
(7/11): perl-Module-Pluggable-3.90-141.el6_7.1.i686.rpm  |  40 kB     00:00     
(8/11): perl-Pod-Escapes-1.04-141.el6_7.1.i686.rpm       |  33 kB     00:00     
(9/11): perl-Pod-Simple-3.13-141.el6_7.1.i686.rpm        | 213 kB     00:00     
(10/11): perl-libs-5.10.1-141.el6_7.1.i686.rpm           | 594 kB     00:00     
(11/11): perl-version-0.77-141.el6_7.1.i686.rpm          |  52 kB     00:00     
--------------------------------------------------------------------------------
Total                                           5.0 MB/s |  22 MB     00:04     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : mysql-libs-5.1.73-7.el6.i686                                1/12 
  Installing : 1:perl-Pod-Escapes-1.04-141.el6_7.1.i686                    2/12 
  Installing : 4:perl-libs-5.10.1-141.el6_7.1.i686                         3/12 
  Installing : 1:perl-Pod-Simple-3.13-141.el6_7.1.i686                     4/12 
  Installing : 3:perl-version-0.77-141.el6_7.1.i686                        5/12 
  Installing : 1:perl-Module-Pluggable-3.90-141.el6_7.1.i686               6/12 
  Installing : 4:perl-5.10.1-141.el6_7.1.i686                              7/12 
  Installing : perl-DBI-1.609-4.el6.i686                                   8/12 
  Installing : perl-DBD-MySQL-4.013-3.el6.i686                             9/12 
  Installing : mysql-5.1.73-7.el6.i686                                    10/12 
  Installing : mysql-server-5.1.73-7.el6.i686                             11/12 
  Cleanup    : mysql-libs-5.1.71-1.el6.i686                               12/12 
  Verifying  : 1:perl-Module-Pluggable-3.90-141.el6_7.1.i686               1/12 
  Verifying  : perl-DBD-MySQL-4.013-3.el6.i686                             2/12 
  Verifying  : mysql-server-5.1.73-7.el6.i686                              3/12 
  Verifying  : 1:perl-Pod-Simple-3.13-141.el6_7.1.i686                     4/12 
  Verifying  : 4:perl-5.10.1-141.el6_7.1.i686                              5/12 
  Verifying  : perl-DBI-1.609-4.el6.i686                                   6/12 
  Verifying  : 4:perl-libs-5.10.1-141.el6_7.1.i686                         7/12 
  Verifying  : mysql-libs-5.1.73-7.el6.i686                                8/12 
  Verifying  : 1:perl-Pod-Escapes-1.04-141.el6_7.1.i686                    9/12 
  Verifying  : mysql-5.1.73-7.el6.i686                                    10/12 
  Verifying  : 3:perl-version-0.77-141.el6_7.1.i686                       11/12 
  Verifying  : mysql-libs-5.1.71-1.el6.i686                               12/12 

Installed:
  mysql-server.i686 0:5.1.73-7.el6                                              

Dependency Installed:
  mysql.i686 0:5.1.73-7.el6                                                     
  perl.i686 4:5.10.1-141.el6_7.1                                                
  perl-DBD-MySQL.i686 0:4.013-3.el6                                             
  perl-DBI.i686 0:1.609-4.el6                                                   
  perl-Module-Pluggable.i686 1:3.90-141.el6_7.1                                 
  perl-Pod-Escapes.i686 1:1.04-141.el6_7.1                                      
  perl-Pod-Simple.i686 1:3.13-141.el6_7.1                                       
  perl-libs.i686 4:5.10.1-141.el6_7.1                                           
  perl-version.i686 3:0.77-141.el6_7.1                                          

Dependency Updated:
  mysql-libs.i686 0:5.1.73-7.el6                                                

Complete!
  • 碰到的问题
    在安装完成后，输入service mysql start 按下回车，报下面这个错
[root@ldx ~]# service mysqld start
Initializing MySQL database:  Installing MySQL system tables...
ERROR: 1004  Can't create file '/tmp/#sql509_1_0.frm' (errno: 13)
170110 13:15:36 [ERROR] Aborting

170110 13:15:36 [Note] /usr/libexec/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/libexec/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!

                                                           [FAILED]
  • 解决方法
#1.停止mysql数据库
/etc/init.d/mysqld stop 
#2.执行如下命令
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

至此，在命令行输入mysql即可进入使用！

[root@ldx ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
L-D-Xiao
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
CentOS安装MySQL 5.7.9
紫眸的博客
12-11 522
在CentOS数据库服务器上安装MySQL 5.7.9 上传mysql安装包：mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz 创建mysql的用户组/用户，用户目录，data目录 groupadd mysql useradd -g mysql -d /home/mysql mysql mkdir /home/mysql/data tar -zxf my...
CentOS 7 安装MySQL
wwlhz的专栏
06-19 1236
CentOS 7 安装MySQL1.使用yum 安装mysql，需要使用mysql的yum仓库，先从官网下载 http://dev.mysql.com/downloads/repo/yum/CentOS 7 使用的是：mysql57-community-release-el7-11.noarch.rpm2.安装mysql仓库： [root@localhost ~]# yum localinst
CentOS6.5上安装MySQL
qq_759035366的博客
07-14 172
CentOS6.5上安装MySQL
centos 6 安装mysql,CentOS6.5安装MySQL教程(完整教程)
weixin_33349121的博客
03-18 959
Step 1：检测系统是否安装MYSQL# yum list installed | grep mysql顺便提下如果yum有如下提示不能用的情况：yum在自动更新原因是yum在自动更新 只要关掉它就OK了解决方案：直接输入# rm -f /var/run/yum.pid或者：# /etc/init.d/yum-updatesd stop当然也可以等更新完了再进行安装继续安装流程：Step ...
【大数据学习篇14】centos6安装Mysql
m0_56073435的博客
06-09 863
2 | 李四 | 88.5 | 68 | 96 | NULL || 2 | 李四 | 88.5 | 68 | 96 | NULL || 2 | 李四 | 88.5 | 68 | 96 | NULL || 2 | 李四 | 88.5 | 68 | 96 | NULL || 2 | 李四 | 88.5 | 68 | 96 |
centos 6.5 安装mysql教程。
Huxt的博客
07-24 443
1. 查看centos自带mysql是否已安装 输入：yum list installed | grep mysql 2. 卸载自带安装的mysql 输入：yum -y remove mysql-libs.x86_64, 同时会卸载多个依赖文件。 当结果显示Complete！即卸载完成。 3. 通过yum来安装mysql，查看yum下提供的mysql数据库可下载的版本。 输入：yum
CentOS 6.5安装mysql
huangeight的博客
12-09 1620
CentOS 6.5的mysql服务安装和配置 一、CentOS 6.5下使用yum源下载前的必要配置 1、CentOS 6.5下使用默认源安装mysql会出错 在使用默认源安装mysql时，会在各种各样的环节出现错误，当你满心欢喜的解决了一个错误的时候。你会惊喜的发现，下一个错误又来找你了，好像时应有尽有的一样。 自带的mysql删除失败： 安装rpm文件失败： 安装mysql服务失败： 2、centos6.5安装失败的原因 原因就是：centos6的默认源在2012年-12月左右被官方删掉了 3、
RedHat6.5/CentOS6.5安装Mysql5.7.20的教程详解
12-16
在Red Hat Enterprise Linux 6.5 (RHEL6.5) 或 CentOS 6.5 上安装MySQL 5.7.20的过程是一个...至此，MySQL 5.7.20已经在RHEL6.5或CentOS6.5上成功安装并配置完毕。记得定期更新和维护MySQL，确保系统的安全性和稳定性。
CentOS 6.5安装mysql5.7教程
12-16
MySQL 5.7可谓是一个令人激动的里程碑，在默认了InnoDB引擎的基础上，新增了ssl、json、虚拟列等新特性。相对于postgreSQL和MariaDB而言，MySQL5.7做了大量“补短”操作。 二、升级操作 1、卸载旧版本 1.1、查看...
CentOS6.5一键安装Mysql5.6
08-28
MySQL安装后，建议执行`mysql_secure_installation`脚本来增强安全性： ``` /usr/bin/mysql_secure_installation ``` 在这个脚本中，你可以设置root用户的密码、删除匿名用户、禁止root远程登录以及删除测试数据库。...
centos6 安装mysql5.6.x版本
11-21
包括软件安装包，详细的安装过程，以及如何修改mysql默认安装位置
centos 6.5配置mysql5.5
07-21
centos 6.5配置mysql5.5
CentOS 6.5下yum安装 MySQL-5.5全过程图文教程
09-10
在linux安装mysql是一个困难的事情，yum安装一般是安装的mysql5.1，现在经过自己不懈努力终于能用yum安装mysql5.5了。下面通过两种方法给大家介绍CentOS 6.5下yum安装 MySQL-5.5全过程，一起学习吧
centos6.5安装mysql5版本
06-09
这篇文章将详细介绍如何在CentOS 6.5上安装MySQL 5版本，以满足日常的Web应用或者数据存储需求。 首先，确保你的系统是最新的。打开终端并运行以下命令来更新你的系统包： ```bash sudo yum update ``` 接下来，...
Centos6.5下安装Mysql 超级详细的步骤
weixin_45014586的博客
04-18 326
我的第一篇博客
centos6.5上安装mysql_Centos6.5 安装mysql
weixin_33680112的博客
03-03 155
搜索热词第1步 查看linux版本[root@stonex ~]#lsb_release -aLSB Version::base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarchDistributor ID:CentOSDescription:CentOS release 6.5 (Final)Release:6.5Codename:...
CentOs6.5安装MySQL5.7 - 2023年
最新发布
weixin_44090146的博客
07-05 351
萌新教程
linux安装mysql
yjk232的博客
11-17 126
1.检测系统是否安装MYSQL 2.删除系统自带MYSQL及其依赖 3.给CentOS添加rpm源，并且选择较新的源 4.安装MYSQL服务器 5.启动MYSQL 6.查看MYSQL是否自启动,并且设置开启自启动 7.查询MYSQL的初始密码 8.登录数据库 9.设置MYSQL允许远程访问 1.允许所有IP访问mysql。 2.让linux防火墙开放mysql的3306端口 1.检测系统是否安装...
mysql 6.5安装配置_CentOS 6.5上MySQL安装部署与入门。
weixin_42117032的博客
01-19 229
centos 6.5 yum 安装mysql1、 安装软件：yum install -y mysql-server mysql mysql-devel2、启动服务：service mysqld start提示信息：[root@localhost init.d]# service mysqld startInitializing MySQL database: Installing MySQL sy...
centos6.5源码安装mysql
04-06
如何在CentOS 6.5上安装MySQL？ 以下是安装步骤： 1. 打开终端并以root权限登录你的CentOS 6.5服务器。 2. 更新你的服务器： ``` yum update ``` 3. 安装MySQL： ``` yum install mysql-server ``` 4...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值