CentOS6 下编译安装 MySQL 5.6.26
centos6 下安装MySQL-python
Centos6.5+ Python-2.7.9+ MySQL-python-1.2.3安装二、安装MySQL-python（1）yum安装yum install MySQL-python -y ---这个安装有些问题（2）源码安装该模块首先安装setuptools，下载源代码包：wget /packages/source/s/setuptools/setuptools-0.6c11.tar.gztar -xzvf setuptools-0.6c11.tar.gzpython setup.py buildpython setup.py install然后安装一些扩展库yum -y install rpm-build gcc-c++ mysql-devel python-devel最后安装MySQL-python下载源代码包：wget /sourceforge/mysql-python/MySQL-python-1.2.3.tar.gz #tar -zxvf MySQL-python-1.2.3.tar.gz编辑site.cfg ，把mysql_config 那一行取消注释，并改为：mysql_config = /usr/lib64/mysql/mysql_config （根据自己mysql安装位置定义）python setup.py buildpython setup.py install测试安装Shell# pythonPython 2.7.9 (default, Apr 13 2015, 16:52:09)[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2Type "help", "copyright", "credits" or "license" for more information.>>> import MySQLdb/usr/lib64/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.py:3: UserWarning: Module _mysql was already imported from /usr/lib64/python2.6/site-packages/MySQL_python-1.2.3-py2.6-linux-x86_64.egg/_mysql.pyc, but /tmp/MySQL-python-1.2.3 is being added to sys.path>>>报出一大堆警告信息，解决办法：删除MySQL-python-1.2.3目录，再测试一下：#rm -fr MySQL-python-1.2.3#python>>> import MySQLdb>>>。
MySQL5.6安装步骤图文详解
MySQL5.6安装步骤图⽂详解MySQL是⼀个开放源码的⼩型关系型数据库管理系统，⽬前MySQL被⼴泛地应⽤在Internet上的中⼩型⽹站中。
由于其体积⼩、速度快、总体拥有成本低，尤其是开放源码这⼀特点，许多中⼩型⽹站为了降低⽹站总体拥有成本⽽选择了MySQL作为⽹站数据库。
但对于刚接触MySQL数据库服务器的朋友来说，可能会感到陌⽣，不知所错，所以下⾯是博主整理的MySQL 5.6版本的安装步骤和图解教程，以及安装完成后在DOS命令窗⼝中检验数据库是否可⽤，以便帮助更多的⼈能够更好的掌握此数据库管理系统的操作。
1、点击下载好的安装⽂件，出现下⾯的界⾯。
2、点击图下图红框中的Install MySQL Products 进⼊安装界⾯。
3、勾选I accept the license terms 点击Next4、Find latest products 检查是否有新版本，可以忽略，直接勾选下⽅红框，然后点击Next5、设置，默认选择第⼀个Develeloper Default。
Installation Path安装路径和Data Path 数据⽂件路径可以使⽤默认路径，也可⾃⾏修改。
6、进⼊安装前环境验证，加载完后点击Execute7、程序检测完毕，点击Next8、点击Excute执⾏，等待下载完毕！⽹络不好就稍耐⼼等待...9、全部下载完毕，点击Next10、继续点击下⼀步Next11、如图，勾选后点击Next12、设置密码，如下图上边的Root Account Password ⼀栏，MySQL Root Password:输⼊密码，Repeat Password:重复密码。
13、如下图，MySQL服务配置，Start the MySQL Server at Systen Startup 是开机的时候是否⾃动启动MySQL服务，⼀般为了节省资源我们设为⼿动，即把对勾取消掉，使⽤数据库的时候在右击-->我的电脑-->管理-->服务和应⽤程序-->服务中开启就OK.14、如图所⽰，可取消对勾，点击Next15、点击Next16、继续点击Next17、点击Finish完成以上安装完成后，我们校来校验⼀下安装的MySQL数据库是否可⽤：1、快捷键Windows+R打开命令窗⼝，如下图：2、输⼊cmd确定，进⼊DOS命令窗⼝，找到安装MySQL⽂件夹下的bin⽬录，接着cd C:\Program Files\MySQL\MySQL\MySQL Server 5.6\bin 回车，进⼊到MySQL安装的bin⽬录中。
linuxCentOS6.5yum安装mysql5.6
linuxCentOS6.5yum安装mysql5.6本⽂为⼤家分享了linux yum安装mysql5.6简单过程，供⼤家参考，具体内容如下1.新开的云服务器，需要检测系统是否⾃带安装mysql# yum list installed | grep mysql2.如果发现有系统⾃带mysql，果断这么⼲# yum -y remove mysql-libs.x86_643.随便在你存放⽂件的⽬录下执⾏，这⾥解释⼀下，由于这个mysql的yum源服务器在国外，所以下载速度会⽐较慢，还好mysql5.6只有79M⼤，⽽mysql5.7就有182M了，所以这是我不想安装mysql5.7的原因# wget /mysql-community-release-el6-5.noarch.rpm4.接着执⾏这句,解释⼀下，这个rpm还不是mysql的安装⽂件，只是两个yum源⽂件，执⾏后，在/etc/yum.repos.d/ 这个⽬录下多出mysql-community-source.repo和mysql-community.repo# rpm -ivh mysql-community-release-el6-5.noarch.rpm5.这个时候，可以⽤yum repolist mysql这个命令查看⼀下是否已经有mysql可安装⽂件#yum repolist all | grep mysql6.安装mysql 服务器命令（⼀路yes）：# yum install mysql-community-server7.安装成功后# service mysqld start8.由于mysql刚刚安装完的时候，mysql的root⽤户的密码默认是空的，所以我们需要及时⽤mysql的root⽤户登录（第⼀次回车键，不⽤输⼊密码），并修改密码# mysql -u root# use mysql;# update user set password=PASSWORD("这⾥输⼊root⽤户密码") where User='root';# flush privileges;9.查看mysql是否⾃启动,并且设置开启⾃启动命令# chkconfig --list | grep mysqld# chkconfig mysqld on10.mysql安全设置(系统会⼀路问你⼏个问题，看不懂复制之后翻译，基本上⼀路yes)：# mysql_secure_installation以上就是本⽂的全部内容，希望对⼤家的学习有所帮助，也希望⼤家多多⽀持。
Centos6.5下安装Apache_mysql_php源码包安装(LAMP环境搭建图文教程)
Centos6.5下安装Apache_mysql_php源码包安装(LAMP环境搭建图文教程)Centos6.5_Apache_mysql_php(LAMP环境搭建图文教程)安装内容详细介绍：编译安装过程介绍一、解压tar.gz为后缀的压缩软件包二、在Centos系统中源代码包安装过程配置（configure）编译（make）安装（make install）各个软件编译安装顺序搭建LAMP环境时，需要安装的所有软件都要按照一定的顺序安装，我们按Apache->MySQL->PHP顺序安装。
但在安装PHP之前，应先安装PHP5需要的最新版本库文件，例如libxml2、libmcrypt以及GD2库等文件。
安装GD2库是为了让PHP5支持GIF、PNG和JPEG图片格式，所以在安装GD2库之前还要先安装最新的zlib、libpng、freetype 和jpegsrc等库文件。
而且中间还会穿插安装一些软件。
读者可以按照本节提供的顺序安装检查安装时使用的编译工具是否存在Gcc -v如果发现gcc没有安装。
可用下面三种方式进行安装：Gcc安装方法1：yum -y install gccyum -y install gcc-c++yum install makeGcc安装方法2：-- 或者yum groupinstall "Development Tools" 一般用这个就好Gcc安装方法3：-- 或者yum install gcc gcc-c++ kernel-devel卸载默认的低版本环境目前发行的Centos操作系统版本中，如果选择默认全部安装，就已经安装了LAMP环境，但是版本相对都比较低。
我们可以再安装一个LAMP环境和原来的并存，但是这样做没有必要，因为同时只能开启一个LAMP环境。
所要我们要在安装之前，先应检查一下系统中是否已经安装了低版本的环境，如果已经安装过了，停止原来的服务运行，或者把原来的环境卸载掉。
centos6.0安装mysql5.6及配置
CentOS 安装MySQL 及配置从今年3月份开始mysql官网开始发布相关的系列的各个版本，对于系列的版本对一路的版本进行了全局性的细节性增强；个人感觉，以下是在虚拟机中配置的源码安装的进程分享记录下：一、必要软件包安装：[root@mysql5~]#yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib * fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake二、编译安装：[root@mysql5 ~]# groupadd mysql[root@mysql5 ~]# useradd -r -g mysql mysql[root@mysql5 ~]# ls~]# cd /usr/local/[root@mysql5 local]# lsbin etc games include lib libexec sbin share src[root@mysql5 local]# cp /root/ /usr/local/[root@mysql5 local]# lltotal 34468drwxr-xr-x 2 root root 4096 Jan 27 2021 bindrwxr-xr-x 2 root root 4096 Jan 27 2021 etcdrwxr-xr-x 2 root root 4096 Jan 27 2021 gamesdrwxr-xr-x 2 root root 4096 Jan 27 2021 includedrwxr-xr-x 2 root root 4096 Jan 27 2021 libdrwxr-xr-x 2 root root 4096 Jan 27 2021 libexec-rw-r--r-- 1 root root Apr 17 00:55 2 root root 4096 Jan 27 2021 sbin drwxr-xr-x 4 root root 4096 Apr 17 00:32 sharedrwxr-xr-x 2 root root 4096 Jan 27 2021 src[root@mysql5 local]# tar -zxvf local]# cd[root@mysql5 local]# cmake . ###编译报如下错误暂无论[ 63%] Building CXX object sql/CMakeFiles//root/ In member function ‘void Optimize_table_order::best_access_path(JOIN_TAB*, table_map, uint, bool, double, POSITION*, POSITION*)’:/root/ warning: ‘::best_loose_scan_start_key’may be used uninitialized in this function/root/ warning: ‘::best_max_loose_keypart’may be used uninitialized in this function/root/ warning: ‘::best_loose_scan_records’may be used uninitialized in this function/root/ warning: ‘::best_loose_scan_key’may be used uninitialized in this function /root/ warning: ‘::quick_max_loose_keypart’may be used uninitialized in this function[root@mysql5 local]# make && make install三、配置MySQL[root@mysql5 chown -R /usr/local/mysql[root@mysql5 cd /usr/local/mysql/scripts/[root@mysql5 scripts]#./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/dataInstalling MySQL system tables...2021-04-17 01:26:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2021-04-17 01:26:58 18715 [Note] InnoDB: The InnoDB memory heap is disabled2021-04-17 01:26:58 18715 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation2021-04-17 01:26:58 18715 [Note] InnoDB: Compressed tables use zlib 01:26:58 18715 [Note] InnoDB: CPU does not support crc32 instructions 2021-04-17 01:26:58 18715 [Note] InnoDB: Initializing buffer pool, size =2021-04-17 01:26:58 18715 [Note] InnoDB: Completed initialization of buffer pool2021-04-17 01:26:58 18715 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!2021-04-17 01:26:59 18715 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2021-04-17 01:26:59 18715 [Note] InnoDB: Database physically writes the file full: wait...2021-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB2021-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB2021-04-17 01:26:59 18715 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile02021-04-17 01:26:59 18715 [Warning] InnoDB: New log files created, LSN=457812021-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer not found: creating new2021-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer created2021-04-17 01:26:59 18715 [Note] InnoDB: 128 rollback segment(s) are active.2021-04-17 01:26:59 18715 [Warning] InnoDB: Creating foreign key constraint system tables.2021-04-17 01:26:59 18715 [Note] InnoDB: Foreign key constraint system tables created2021-04-17 01:26:59 18715 [Note] InnoDB: Creating tablespace and datafile system tables.2021-04-17 01:26:59 18715 [Note] InnoDB: T ablespace and datafile system tables created.2021-04-17 01:26:59 18715 [Note] InnoDB: Waiting for purge to start2021-04-17 01:26:59 18715 [Note] InnoDB: started; log sequence number 02021-04-17 01:26:59 18715 [Note] Binlog end2021-04-17 01:26:59 18715 [Note] InnoDB: FTS optimize thread exiting.2021-04-17 01:26:59 18715 [Note] InnoDB: Starting shutdown...2021-04-17 01:27:00 18715 [Note] InnoDB: Shutdown completed; log sequence number 1625977OKFilling help tables...2021-04-17 01:27:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2021-04-17 01:27:00 18738 [Note] InnoDB: The InnoDB memory heap is disabled2021-04-17 01:27:00 18738 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation2021-04-17 01:27:00 18738 [Note] InnoDB: Compressed tables use zlib 01:27:00 18738 [Note] InnoDB: CPU does not support crc32 instructions 2021-04-17 01:27:00 18738 [Note] InnoDB: Initializing buffer pool, size =2021-04-17 01:27:00 18738 [Note] InnoDB: Completed initialization of buffer pool2021-04-17 01:27:00 18738 [Note] InnoDB: Highest supported file format is Barracuda.2021-04-17 01:27:00 18738 [Note] InnoDB: 128 rollback segment(s) are active.2021-04-17 01:27:00 18738 [Note] InnoDB: Waiting for purge to start2021-04-17 01:27:01 18738 [Note] InnoDB: started; log sequence number 16259772021-04-17 01:27:01 18738 [Note] Binlog end2021-04-17 01:27:01 18738 [Note] InnoDB: FTS optimize thread exiting.2021-04-17 01:27:01 18738 [Note] InnoDB: Starting shutdown...2021-04-17 01:27:02 18738 [Note] InnoDB: Shutdown completed; log sequence number 1625987OKTo start mysqld at boot time you have to copysupport-files/ to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/local/mysql/bin/mysqladmin -u root password 'new-password'/usr/local/mysql/bin/mysqladmin -u root -h password 'new-password'Alternatively you can run:/usr/local/mysql/bin/mysql_secure_installationwhich will also give you the option of removing the testdatabases and anonymous user created by default. This isstrongly recommended for production servers.See the manual for more instructions.You can start the MySQL daemon with:cd . ; /usr/local/mysql/bin/mysqld_safe &You can test the MySQL daemon withcd mysql-test ; perlPlease report any problems with the ./bin/mysqlbug script!The latest information about MySQL is available on the web atMySQL by buying support/licenses at default config file was created as /usr/local/mysql/ andwill be used by default by the server when you start it.You may edit this file to change server settingsWARNING: Default config file /etc/ exists on the systemThis file will be read by default by the MySQL serverIf you do not want to use this, either remove it, or use the--defaults-file argument to mysqld_safe when starting the server[root@mysql5 scripts]#[root@mysql5 scripts]# cd /usr/local/mysql/support-files/[root@mysql5 support-files]# cp /etc/mysqlcp: overwrite `/etc/mysql'? y[root@mysql5 support-files]# cp /etc/cp: overwrite `/etc/'? y[root@mysql5 support-files]#[root@mysql5 support-files]# chkconfig -add mysql-add: unknown option[root@mysql5 support-files]# chkconfig --add mysql[root@mysql5 support-files]# chkconfig mysql on[root@mysql5 support-files]# service mysql startStarting MySQL. [ OK ] [root@mysql5 support-files]#[root@mysql5 data]# mysql -u mysql -p -S /tmp/Enter password:Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1Server version: Source distributionType 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>mysql> status;--------------mysql Ver Distrib for RedHat-linux-gnu (i686) using readline Connection id: 1Current database:Current user: mysql@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: latin1Db characterset: latin1Client characterset: latin1Conn. characterset: latin1UNIX socket: /tmp/Uptime: 3 min 38 secThreads: 1 Questions: 5 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg:--------------mysql>四、远程登录及常常利用命令一、mysql服务的启动和停止net stop mysqlnet start mysql二、本地登岸mysql 及远程登录语法如下：mysql -u用户名-p用户密码键入命令mysql –u root -p，回车后提示你输入密码，输入12345，然后回车即可进入到mysql中了，mysql的提示符是：mysql>注意，若是是连接到另外的机械上，则需要加入一个参数-h机器IP但被远程登录的mysql服务器需增加登录账号，方式如下：mysql>GRANT ALL PRIVILEGES ON *.* TO USER1@’%’IDENTIFIED BY ’password’mysql>FLUSH PRIVILEGES;3、增加新用户格式：grant 权限on 数据库.* to 用户名@登录主机identified by "密码"如，增加一个用户user1密码为password1，让其可以在本机上登录，并对所有数据库有查询、插入、修改、删除的权限。
CentOS 6.3源码安装mysql 5.6方法
本文主要介绍在CentOS 6.3系统上通过源码方式安装最新的mysql 5.6.10版本的方法，转自.1：下载mysql下载地址为：/downloads/mysql/5.6.html#downloads选择“Source Code”->”Generic Linux (Architecture Independent), Compressed TAR Archive”2：安装必要的软件包yum -y install gccgcc-c++ gcc-g77 autoconfautomakezlib* fiex* libxml* ncurses-devellibmcrypt* libtool-ltdl-devel* make cmake3:编译安装[root@server100 ~]# groupaddmysql[root@server100 ~]# useradd -r -g mysqlmysql[root@server100 ~]# tar -zxvf mysql-5.6.10.tar.gz[root@server100 ~]# cd mysql-5.6.10[root@server100 mysql-5.6.10]# cmake .[root@server100 mysql-5.6.10]# make&& make install-------------默认安装目录为/usr/local/mysql[root@server100 ~]# chown -R mysql.mysql /usr/local/mysql[root@server100 ~]# cd /usr/local/mysql/scripts[root@server100 ~]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data[root@server100 ~]# cd /usr/local/mysql/support-files[root@server100 support-files]# cpmysql.server /etc/rc.d/init.d/mysql[root@server100 support-files]# cp f /etc/f[root@server100 ~]# chkconfig -add mysql[root@server100 ~]# chkconfigmysql on[root@server100 ~]# servicemysql startStarting MySQL SUCCESS![root@server100 support-files]# mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Y our MySQL connection id is 1Server version: 5.6.10 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help.Type '\c' to clear the current input statement.mysql>mysql> status;--------------mysqlV er 14.14 Distrib 5.6.10, for Linux (i686) using EditLine wrapperConnection id: 1Current database:Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.6.10 Source distributionProtocol version: 10Connection: Localhost via UNIX socketServer characterset: utf8Dbcharacterset: utf8Client characterset: utf8Conn. characterset: utf8UNIX socket: /tmp/mysql.sockUptime: 5 min 45 secThreads: 1 Questions: 5 Slow queries: 0 Opens: 70 Flush tables: 1 Open tables: 63 Queries per second avg: 0.014--------------mysql>至此mysql安装完毕。
Centos下的MySQL安装及配置
Centos下的MySQL安装及配置⾥使⽤的是VMware虚拟机和系统虚拟机安装这⾥不多讲，⽹上教程很多了，这⾥就介绍下虚拟机的⽹络配置。
虚拟机⽹络配置Centos⽹络连接模式这⾥设置为桥接模式，不⽤勾选复制物理⽹络连接状态然后安装好通过命令⾏$su 下⼀⾏输⼊密码获得root⽤户权限$cd /etc/sysconfig/network-scripts 进⼊该⽬录$vi ifcfg-ens33 ⽂件这⾥⽂件名可能不⼀样我们等会通过Xshell连接到虚拟机，这⾥我们就固定虚拟机IP。
将BOOTPROTO 设置为none或者static;ONBOOT 开机是否启动⽹卡 yesIPV6没⽤设置为no;这⾥IPADDR (虚拟机Ip地址)和GATEWAY(⽹关)注意下：打开Windows的cmd ，输⼊ ipConfig /all 查看主机的⽹络配置信息虚拟机IP地址需要和主机IP地址在同⼀⽹段，默认⽹关需相同。
配置好后可以在虚拟机中 ping 查看⽹络是否连接。
最后就可以通过Xshell连接虚拟机，教程也很多这⾥不多赘述。
在Xshell中配置MySQL⾸先安装 wget 服务相当于软件仓库。
命令⾏：yum install wget -y 安装wget服务wget https:///get/Down1oads/MySQL-8.0/mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz 安装mysql的压缩⽂件xz -d mysql-8.0.15-linux-glibc2.12-x86_64.tar.xz 解压由xz⽂件转换为tar在通过 tar -xvf mysql-8.0.15-linux-glibc2.12-x86_64.tar 提取⽂件然后将 mysql-8.0.15-linux-glibc2.12-x86_64⽂件移动到 /usr/local/mysql ⽬录mv mysql-8.0.15-linux-glibc2.12-x86_64 /usr/local/mysql启动mysql添加mysql账号adduser mysql替换 /etc/f⽂件这⾥提供该⽂件下载my.zip解压然后继续在mysql⽬录下建⽴是三个⽬录mkdir data(数据库⽂件) sql_log(⽇志⽂件) undo将这是三个⽬录更改⽤户为mysqlchown mysql:mysql -R data/ sql_log/ undo/初始化MYSQL配置系统变量vi /etc/profile⽂件末尾添加 export PATH=$PATH:/usr/local/mysql/binsource /etc/profile 变量⽣效初始化mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data然后继续在mysql⽬录下cd support-filescp mysql.server /etc/init.d/mysqld/etc/init.d/mysqld start 启动mysql服务更改mysql登录密码还是在mysql⽬录下cd sql_loggrep password mysql-error.log初始密码红框标记mysql -uroot -p 登录mysqlalter user user() identified by '新密码';图形化界⾯连接Linux下的mysql下⾯我们使⽤SQLyog 连接Linux下的 mysql；在这个过程中你可能会遇到错误代码2003；解决⽅案：关闭 linux 防⽕墙错误代码1130; 解决⽅案：给数据库授权命令⾏：$ mysql -uroot -pEnter password:mysql> show database;mysql> use mysql;mysql> update `user` set `host` = '%' where `user` = 'root';mysql> flush privileges;mysql> exit;Bye注意这⾥的反引号；再次连接成功；DCL(数据库访问控制语句)创建数据库⽤户：CREATE USER username@'ip' IDENTIFIED BY 'password' WITH MAX_USER_CONNECTIONS 1;给账户进⾏授权GRANT SELECT,DELETE ON tablename TO username@'ip' ;收回账户权限REVOKE SELECT,DELETE ON tablename TO username@'ip';。
CentOS6.4 mysql5.6安装配置
内部环境：x86-64服务器，操作系统centos6.4；由于centos6.4自带的mysql版本过低，所以首先删除原来的版本，再安装新版本，新版本如下：.tar1.执行如下吩咐rpm -qa | grep mysql发觉系统默认安装的mysql版本如下图，版本过低，我们须要安装mysql5.62.删除默认的mysql (留意rpm吩咐不能运用*号)执行rpm -qa | grep mysql直到不会再查询到mysql3. 解压缩#tar -xf MySQL*.tar 我们仅仅安装如下两个rpm包上传两个文件到服务器4.执行吩咐rpm -ivh MySQL-server-rpm -ivh MySQL-client-安装完毕==========================安装过程中的提示=====================1. A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in '/root/.mysql_secret'You must change that password on your first connect,no other statement but 'SET PASSWORD' will be accepted.所以root用户密码可以在这里修改2. New default config file was created as /usr/my f andwill be used by default by the server when you start it.You may edit this file to change server settings可以查看/usr/my f进行相关设置============================================================5.启动mysql/etc/init.d/mysql start6.首次登录mysql，修改密码获得初始密码cat /root/.mysql_secret运用root用户登录mysql -uroot -p输入前面查询到的初始密码，登录胜利后如下图修改密码set password = password('123456'); 红框中是须要的新密码7.给全部机器授权登录此mysqlGRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;8.开启防火墙(这一步可以用图形界面的方式开放防火墙端口)【linux默认安装后，防火墙没有开放3306端口，而mysql默认运用此端口；执行吩咐如下iptables -I INPUT -p tcp --dport 3306 -j ACCEPT/etc/rc.d/init.d/iptables saveservice iptables restart// 重启生效此时可以看到3306端口打开】9.打开/etc/selinux/config，把SELINUX=enforcing改为SELINUX=disabled后存盘退出重启机器【第九步不须要执行也可以】10.登录验证举荐运用sqlyog客户端登录FAQ:1.mysql数据书目还须要调整，后续文档给出调整方案2.目前mysql的配置（缓存之类的）是根据默认的，短暂可以运用，后续须要调整参数。
Centos-6.5-使用yum安装-mysql+Apache+php教程
Centos 6.5 使用yum安装mysql+Apache+php教程一、安装mysql#yum -y install mysql mysql-server mysql-devel配置mysql开机启动服务#chkconfig --add mysqld (在服务清单中添加mysql服务)#chkconfig mysqld on (设置mysql服务随开机启动)#mysql_secure_installation（设置mysql密码）回车，根据提示输入Y输入2次密码，回车根据提示一路输入Y或N最后出现：Thanks for using MySQL!MySql密码设置完成，重新启动 MySQL：Remove anonymous users)删除匿名账号Disallow root login remotely)取消root用户远程登录Remove test database and access to it)删除test库和对test库的访问权限Reload privilege tables now)刷新授权表使修改生效#service mysqld start (启动mysql服务)二、使用yum命令安装Apache#yum –y install httpd1、设置开机启动Apache#chkconfig --levels 235 httpd on2、启动Apache#/etc/init.d/httpd start3、现在直接在浏览器键入http://localhost或http://本机IP，会看到Apache 的测试页面三、安装PHP#yum -y install php#service httpd restart (重启apache)#vi /var/www/html/index.php输入以下的测试代码<?phpphpinfo();?>保存退出，用IE访问http://IP 如果输出了phpinfo信息说明你的php安装成功了安装php的相关组件#yum search php (搜索php相关的组件)#yum -y install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc安装完成后重启apache服务#service httpd restart。
centos6.2 编译安装mysql5.5
centos6.2 编译安装mysql5.5第一步：我们首先安装依赖库和开发工具#依赖库和开发工具yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers#Nginxyum -y install pcre-devel zlib-devel#Phpyum -y install gd-devel libjpeg-devel libpng-devel freetype-devel libxml2-devel curl-devel freetype-devel#Mysqlyum -y install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel* mysql-devel第二步：由于mysql5.5开始，不再使用configure安装，而是使用cmake。
所以需要先安装cmakewget /files/v2.8/cmake-2.8.6.tar.gztar -zxvf cmake-2.8.6.tar.gzcd cmake-2.8.6/./configuremake && make install第三步：cmake安装mysql（我已经下载好了mysql源码文件，放在U盘里，拷贝到/tmp目录下）//进入/tmp目录下tar -zxvf mysql-5.5.25.tar.gzcd mysql-5.5.25cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/user/local/mysql/data \-DSYSCONFDIR=/etc \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_DEBUG=0 \-DENABLED_LOCAL_INFILE=1回车执行，执行完成后继续执行 make && make install第四步：设置mysql#设置Mysql#在support-files目录中有五个配置信息文件(这里很重要，一定要根据自己的内存复制对应的cnf文件，否则mysql始终起不来)：#f (内存<=64M)#f (内存 128M)#f (内存 512M)#f (内存 1G-2G)#f (内存 4GB)cd /usr/local/webserver/mysqlcp ./support-files/f /etc/fvi /etc/f#在 [mysqld] 段增加datadir = /data/mysqlwait-timeout = 30max_connections = 512default-storage-engine = MyISAM#在 [mysqld] 段修改max_allowed_packet = 16M第五步：添加mysql用户和用户组，生成新的mysql授权表//添加mysql运行的用户和用户组groupadd mysqluseradd -g mysql mysql -s /bin/false -d /home/mysql //没有shell，不可本机登陆（安全起见）cd /usr/local/webserver/mysqlchown -R root .chown -R mysql datachgrp -R mysql .//生成新的mysql授权表//进入mysql安装目录下的脚本目录cd /usr/local/webserver/mysql/scripts//利用mysql_install_db脚本生成新的mysql授权表./mysql_install_db --basedir=/usr/local/webserver/mysql --datadir=/usr/local/webserver/mysql/data --user=mysql//mysql server在系统中的服务项设置//复制服务文件并修改cd /usr/local/webserver/mysql/support-filescp mysql.server mysqld//修改mysqldbasedir=/usr/local/webserver/mysqldatadir=/usr/local/webserver/mysql/datamv mysqld /etc/init.d/mysqldchmod 755 /etc/init.d/mysqld//设置软连接使mysql, mysqldump, mysqladmin这三个bin命令能在shell中直接运行sudo ln -s /usr/local/webserver/mysql/bin/mysql /usr/binsudo ln -s /usr/local/webserver/mysql/bin/mysqldump /usr/binsudo ln -s /usr/local/webserver/mysql/bin/mysqladmin /usr/binrm -rf /etc/mysql/f 因为已经把此文件复制到/etc/f 如果不删除的话，mysql 启动不起来。
Linux CentOS6.5下编译安装MySQL 5.6.16
一、编译安装MySQL前的准备工作安装编译源码所需的工具和库[sql]view plaincopy1.yum install gcc gcc-c++ ncurses-devel perl安装cmake，从下载源码并编译安装[sql]view plaincopy1.wget /files/v2.8/cmake-2.8.10.2.tar.gz2.tar -xzvf cmake-2.8.10.2.tar.gz3.cd cmake-2.8.10.24../bootstrap ; make ; make install5.cd ~二、设置MySQL用户和组新增mysql用户组[sql]view plaincopy1.groupadd mysql新增mysql用户[sql]view plaincopyeradd -r -g mysql mysql三、新建MySQL所需要的目录新建mysql安装目录[sql]view plaincopy1.mkdir -p /usr/local/mysql新建mysql数据库数据文件目录[sql]view plaincopy1.mkdir -p /data/mysqldb四、下载MySQL源码包并解压从/downloads/mysql/直接下载源码，解压mysql-5.6.16.tar.gz（/这个网站就是用的5.6.16版本）[sql]view plaincopy1.wget /files/mysql-5.6.16.tar.gz2.tar -zxv -f mysql-5.6.16.tar.gz3.cd mysql-5.6.16设置编译参数[sql]view plaincopy1.cmake \2.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \3.-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \4.-DDEFAULT_CHARSET=utf8 \5.-DDEFAULT_COLLATION=utf8_general_ci \6.-DWITH_INNOBASE_STORAGE_ENGINE=1 \7.-DWITH_ARCHIVE_STORAGE_ENGINE=1 \8.-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \9.-DMYSQL_DATADIR=/data/mysqldb \10.-DMYSQL_TCP_PORT=3306 \11.-DENABLE_DOWNLOADS=1注：重新运行配置，需要删除CMakeCache.txt文件[sql]view plaincopy1.rm CMakeCache.txt编译源码[sql]view plaincopy1.make安装[sql]view plaincopy1.make install六、修改mysql目录所有者和组修改mysql安装目录[sql]view plaincopy1.cd /usr/local/mysql2.chown -R mysql:mysql .修改mysql数据库文件目录[sql]view plaincopy1.cd /data/mysqldb2.chown -R mysql:mysql .七、初始化mysql数据库[sql]view plaincopy1.cd /usr/local/mysql2.scripts/mysql_install_db --user=mysql --datadir=/data/mysqldb八、复制mysql服务启动配置文件[sql]view plaincopy1.cp /usr/local/mysql/support-files/f /etc/f注：如果/etc/f文件存在，则覆盖。
CENTOS6.2上装mysql5.5和5.6
博雅网基础服务（轻应用）CENTOS6.2 安装mysql5.5以及5.61.Mysql5.6.10安装一．必要软件：yum -y install gcc gcc-c++ autoconf automake bison ncurses-devel libtool-ltdl-devel* cmake make二．编译安装[root@localhost src]#groupadd mysql[root@localhost src]# useradd mysql -g mysql[root@localhost src]# pwd/usr/local/src[root@localhost src]#mkdir /data/mysql/data -p[root@localhost src]# mkdir /usr/local/mysql[root@localhost src]# lsmysql-5.6.10.tar.gzCm/pwd[root@localhost src]# tar -zvxf mysql-5.6.10.tar.gzCmake软件可以编译安装也可以不编译安装目前未发现不编译安装有什么问题Rpm包cmake在centos中版本是2.6.4-5.el6至于为什么编译安装cmake我个人认为是由于在rhel5中没有或者版本过低有些mysql的安装还是进行在rhel5之上在cmake的官网上也正是这两种版本2.6.4是始终有下载的下载cmake11.2.1版本[root@localhost src]# wget /files/v2.8/cmake-2.8.12.1.tar.gz[root@localhost src]# tar -zvxf cmake-2.8.12.1.tar.gz[root@localhost src]# cd cmake-2.8.12.1[root@localhost cmake-2.8.12.1]# ./bootstrap[root@localhost cmake-2.8.12.1]#make&&make install[root@localhost cmake-2.8.12.1]# cmake --help |head -n1cmake version 2.8.12.1[root@localhost cmake-2.8.12.1]# cd /usr/local/src/mysql-5.6.10/storage有哪些存储引擎的支持可以看一个目录[root@localhost storage]# lsarchive csv federated innobase myisammrg perfschemablackhole example heap myisam ndb[root@localhost storage]# pwd/usr/local/src/mysql-5.6.10/storage[root@localhost storage]# cd /usr/local/src/mysql-5.6.10[root@localhost mysql-5.6.10]#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \-DMYSQL_DATADIR=/data/mysql/data/ \-DSYSCONFDIR=/etc \-DWITH_TCP_PORT=3306 \-DMYSQL_USER=mysql \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS:STRING=all \-DENABLED_LOCAL_INFILE=1 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_READLINE=1参数配置详细解释：其实5.6版本可以所有的关于引擎的参数不填写因为默认是全部给安装的而5.5则不同关于-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \ 这三个是必须要自己填写的否则的话只能编译出6个引擎;# /* -DWITH_READLINE=1 # 快捷键功能# /* -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysqld.sock # 连接数据库socket路径# /* -DMYSQL_TCP_PORT=3306 # 端口# /* -DENABLED_LOCAL_INFILE=1 # 允许从本地导入数据[root@localhost src]#make && make install[root@localhost src]#cd /usr/local/mysql/scripts/[root@localhostsrc]#./mysql_install_db --user=mysql --datadir=/data/mysql/data --basedir=/usr/local/mysql[root@localhost src]#cd /usr/local/mysql/support-files/[root@localhost src]#cp mysql.server /etc/init.d/mysqld[root@localhost src]#chmod 755 /etc/init.d/mysqld[root@localhost src]#cat >>/etc/profile <<EOFexport PA TH=$PATH:/usr/local/mysql/binEOF[root@localhost src]#source /etc/profile[root@localhost src]#cd /usr/local/mysql/support-files/[root@localhost support-files]#cp -f f /etc/f[root@localhost support-files]#cat >> /etc/f <<EOFlog-bin=mysql-binexpire_logs_days=10binlog_format=mixedtable_definition_cache=10000max_connections=1000key_buffer_size=256Mtmp_table_size=64Mread_buffer_size=4Mread_rnd_buffer_size=16Msort_buffer_size=64Mthread_cache_size=80wait_timeout=7200thread_concurrency = 8innodb_buffer_pool_size=1024Minnodb_sort_buffer_size=4Minnodb_thread_concurrency=4innodb_flush_log_at_trx_commit = 2EOF[root@client100 support-files]#chown mysql.mysql /etc/f# 将安装目录属主改为mysql[上面更改，到这里又变成root属主了，所以可以选择更改为mysql][root@client100 support-files]#chkconfig --add mysqld[root@client100 support-files]#chkconfig mysqld on[root@localhost support-files]# chkconfig --list |grep mysql --234必须为on[root@client100 support-files]#service mysqld start[root@client100 support-files]#echo "drop user 'root'@'::1';drop user ''@'localhost';drop user 'root'@'localhost.localdomain';"|mysql[root@client100 support-files]#mysqladmin -u root password '123456'---------------------------------------------------------------------如果起数据库报错多半不外乎两种可能第一种是你[root@localhostsrc]#./mysql_install_db --user=mysql --datadir=/data/mysql/data --basedir=/usr/local/mysql路径不对那么重新执行这句第二种则是你有老的数据库没有关闭或者你多次service mysqld start导致的。
Linux CentOS6.5下源码安装多个Mysql5.6
Linux CentOS6.5源码安装多个Mysql5.6版本说明目录1.环境搭建说明 ............................................................................................................... 错误！未定义书签。
2.Wmware虚拟机安装Linux环境 (5)3. Linux CentOS6.5下源码安装多个MySql6.5 (9)3.1.切换到root账户下 (9)3.2.第一个mysql安装 (10)3.3.第二个mysql安装 (13)4. Cmake 参数说明 ........................................................................................................... 错误！未定义书签。
1.环境搭建说明Linux CentOS6.5 64位操作系统vmware10 虚拟机Mysql5.6 数据库2.Wmware虚拟机安装Linux环境 2.1创建Linux 虚拟机2.2选择Linux CentOS6.5系统镜像文件2.3新建系统账户密码，此处随意（root默认为此处设置的密码）2.4选择虚拟机安装地址和容量2.5为了方便拖拽文件，复制文本内容，还要安装VMware Tools1.点击虚拟机选项卡，选择安装VMware Tools，桌面会生成VMWare Tools虚拟光驱图标，双击2.将VMareTools-9.6.1.-1378637.tar.gz 拖到/root/Downloads 目录下进行解压[root@localhost ~]# cd Downloads[root@localhost Downloads]# tar zxvf VMareTools-9.6.1.-1378637.tar.gz3.进入解压目录,安装vmware-install.pl[root@localhost Downloads]# cd vmware-tools-distrib[root@localhost vmware-tools-distrib]# ./vmware-install.pl一路回车~~~4.出现如下界面表示成功，重启CentOS3.Linux CentOS6.5下源码安装多个MySql6.53.1切换到root账户下注：root密码为安装CentOS时设置的密码3,2第一个mysql安装3.2.1安装系统相关库文件 gcc gcc-c++ ncurses-deve; bison[root@localhost ~]# yum install gcc gcc-c++ ncurses-devel bison 注：安装编译环境和需要make的内核环境包ncurses-devel和bison rpm -q xxx:可查看本机是否已安装这些库文件，xxx为相应库文件名3.2.2 yum方式安装cmake[root@localhost ~]# yum -y install mysql-server cmake3.2.3 设置mysql用户和组[root@localhost ~]# groupadd mysql[root@localhost ~]# useradd -r -g mysql mysql3.2.4 mysql安装1.新建mysql所需要的目录[root@localhost ~]# mkdir -p /usr/local/mysql 新建mysql安装目录[root@localhost ~]# mkdir -p /usr/local/mysql/data 新建mysql数据库数据文件目录2.mysql源码文件下载并拖动到/root根目录中下载地址：/downloads/mysql/依次点击 Community-->MySQL Community Server选择Source Code选择最后一个Generic Linux 下载下载好后将mysql源码文件拖动到/root根目录中3.解压mysql源码文件[root@localhost ~]# tar -zxv -f mysql-5.6.22.tar.gz4.进入解压目录,开始cmake[root@localhost ~]# cd mysql-5.6.22[root@localhost mysql-5.6.22]# make clean[root@localhost mysql-5.6.22]# rm -f CMakeCache.txt[root@localhost mysql-5.6.22]# rm -rf /etc/f[root@localhost mysql-5.6.22]#cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DMYSQL_DATADIR=/usr/local/mysql \-DMYSQL_TCP_PORT=3306 \-DENABLE_DOWNLOADS=1[root@localhost mysql-5.6.22]# make;make install等待大概20多分钟~~~注：cmake这段建议手敲进终端，复制可能提示找不到文件目录（目录确实是存在的），可能是编码不一致引起。
centos下MySQLLinux Generic 安装步骤
6、启动mysql5.6.26服务
?
1
/usr/local/mysql/bin/mysqld_safe--defaults-file=./f--user=mysql&
如果没有报错，且日志文件/usr/local/mysql/mysqld.log里没有错误信息，基本就已经启动好了，可以通过ps查看进程
2、下载之后，解压安装包
?
1
tar-zxvfmysql-5.6.26-linux-glibc2.5-x86_64.tar.gz
然后通过cp指令复制解压出来的文件夹草/usr/local/mysql/（一定要将安装文件复制到mysql的安装目录下）
?
1
cp-frmysql-5.6.26-linux-glibc2.5-x86_64/*mysql
18
19
20
21
22
23
24
25
cat/etc/f
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
3、创建用户（如果已创建，忽略此步骤）
?
1
2
groupaddmysql
useradd-gmysqlmysql
4、安装mysql5.6.26
?
1
/usr/local/mysql/scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/data/mysql--user=mysql
LinuxCentOS6.5下编译安装MySQL5.6.16
LinuxCentOS6.5下编译安装MySQL5.6.16⼀、编译安装MySQL前的准备⼯作安装编译源码所需的⼯具和库[sql]view plaincopy1.yum install gcc gcc-c++ ncurses-devel perl安装cmake，从/doc/cc14801405.html下载源码并编译安装[sql]view plaincopy1.wget /doc/cc14801405.html/files/v2.8/cmake-2.8.10.2.tar.gz2.tar -xzvf cmake-2.8.10.2.tar.gz3.cd cmake-2.8.10.24../bootstrap ; make ; make install5.cd ~⼆、设置MySQL⽤户和组新增mysql⽤户组[sql]view plaincopy1.groupadd mysql新增mysql⽤户[sql]view plaincopy/doc/cc14801405.htmleradd -r -g mysql mysql三、新建MySQL所需要的⽬录新建mysql安装⽬录[sql]view plaincopy1.mkdir -p /usr/local/mysql新建mysql数据库数据⽂件⽬录[sql]view plaincopy1.mkdir -p /data/mysqldb四、下载MySQL源码包并解压从/doc/cc14801405.html/downloads/mysql/直接下载源码，解压mysql-5.6.16.tar.gz（/doc/cc14801405.html /这个⽹站就是⽤的5.6.16版本）[sql]view plaincopy1.wget /doc/cc14801405.html/files/mysql-5.6.16.tar.gz2.tar -zxv -f mysql-5.6.16.tar.gz3.cd mysql-5.6.16设置编译参数[sql]view plaincopy1.cmake \2.-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \3.-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \4.-DDEFAULT_CHARSET=utf8 \5.-DDEFAULT_COLLATION=utf8_general_ci \6.-DWITH_INNOBASE_STORAGE_ENGINE=1 \7.-DWITH_ARCHIVE_STORAGE_ENGINE=1 \8.-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \9.-DMYSQL_DATADIR=/data/mysqldb \10.-DMYSQL_TCP_PORT=3306 \11.-DENABLE_DOWNLOADS=1注：重新运⾏配置，需要删除CMakeCache.txt⽂件[sql]view plaincopy 1.rm CMakeCache.txt编译源码[sql]view plaincopy1.make安装[sql]view plaincopy1.make install六、修改mysql⽬录所有者和组修改mysql安装⽬录[sql]view plaincopy1.cd /usr/local/mysql2.chown -R mysql:mysql .修改mysql数据库⽂件⽬录[sql]view plaincopy1.cd /data/mysqldb2.chown -R mysql:mysql .七、初始化mysql数据库[sql]view plaincopy1.cd /usr/local/mysql2.scripts/mysql_install_db --user=mysql --datadir=/data/mysqldb⼋、复制mysql服务启动配置⽂件[sql]view plaincopy1.cp /usr/local/mysql/support-files//doc/cc14801405.htmlf /etc//doc/cc14801405.htmlf注：如果/etc//doc/cc14801405.htmlf⽂件存在，则覆盖。
CentOS6.6下MySQL5.17升级5.6失败解决方法
CentOS6.6下MySQL5.17升级5.6失败解决⽅法CentOS 6.6⾃带安装了MySQL 5.1，但5.1有诸多限制，⽽实际开发中，我们也已经使⽤MySQL 5.6，这导致部分脚本在MySQL 5.1中执⾏会出错。
我们只能升级MySQL。
1、备份数据库，升级MySQL通常不会丢失数据，但保险起见，我们需要做这⼀步。
输⼊命令：mysqldump -u xxx -h xxx -P 3306 -p --all-databases > databases.sql2、停⽌MySQL服务，输⼊命令：执⾏过程中会询问你是否移除，此时输⼊“Y”1. 44、移除命令执⾏后，可再看看是否有残余的mysql，输⼊命令：yum list installed | grep mysql如果有，可输⼊命令删除：rum remove mysql－libs1. 55、下载安装最新的rpm⽂件rpm -Uvh /doc/7d70c857bc64783e0912a21614791711cd797901.html /mysql-community-release-el6-5.noarch.rpmyum install mysql-community-server7、安装完成后，输⼊命令查看MySQL版本号：mysql -V8、启动MySQL，输⼊命令：（结果就这么坑了）service mysqld start9、查询⽇志，看报错内容tail -f /var/log/mysqld.log[root@localhost ~]# tail -f /var/log/mysqld.log2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'MEMORY' 2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'MyISAM' 2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'CSV' 2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'sha256_password'2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'mysql_old_password'2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'mysql_native_password'2016-08-15 17:34:48 5298 [Note] Shutting down plugin 'binlog' 2016-08-15 17:34:48 5298 [Note] /usr/sbin/mysqld: Shutdown complete160815 17:34:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended160815 17:36:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql2016-08-15 17:36:42 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2016-08-15 17:36:42 0 [Note] /usr/sbin/mysqld (mysqld 5.6.32) starting as process 5642 ...2016-08-15 17:36:42 5642 [Note] Plugin 'FEDERATED' is disabled.2016-08-15 17:36:42 5642 [Note] InnoDB: Using atomics to ref count buffer pool pages2016-08-15 17:36:42 5642 [Note] InnoDB: The InnoDB memory heap is disabled2016-08-15 17:36:42 5642 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2016-08-15 17:36:42 5642 [Note] InnoDB: Memory barrier is not used2016-08-15 17:36:42 5642 [Note] InnoDB: Compressed tables use zlib 1.2.32016-08-15 17:36:42 5642 [Note] InnoDB: Using Linux native AIO 2016-08-15 17:36:42 5642 [Note] InnoDB: Using CPU crc32 instructions2016-08-15 17:36:42 5642 [Note] InnoDB: Initializing buffer pool, size = 128.0M2016-08-15 17:36:42 5642 [Note] InnoDB: Completed initialization of buffer pool2016-08-15 17:36:42 5642 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!2016-08-15 17:36:42 5642 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in /doc/7d70c857bc64783e0912a21614791711cd797901.html f back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your preciousdata!2016-08-15 17:36:42 5642 [ERROR] Plugin 'InnoDB' init function returned error.2016-08-15 17:36:42 5642 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2016-08-15 17:36:42 5642 [ERROR] Unknown/unsupported storage engine: InnoDB2016-08-15 17:36:42 5642 [ERROR] Aborting2016-08-15 17:36:42 5642 [Note] Binlog end2016-08-15 17:36:42 5642 [Note] Shutting down plugin'partition'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'BLACKHOLE'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_SYS_TABLES'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_FT_CONFIG'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_FT_DELETED'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_METRICS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_CMPMEM'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_CMP_RESET'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_CMP'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_LOCKS'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'INNODB_TRX'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'ARCHIVE' 2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'MRG_MYISAM'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'MEMORY' 2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'MyISAM' 2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'CSV' 2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'sha256_password'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'mysql_old_password'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'mysql_native_password'2016-08-15 17:36:42 5642 [Note] Shutting down plugin 'binlog'2016-08-15 17:36:42 5642 [Note] /usr/sbin/mysqld: Shutdown complete160815 17:36:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid endedtail -f /var/log/messages[root@localhost ~]# tail -f /var/log/messagesAug 15 17:18:44 localhost dhclient[3412]: DHCPACK from 192.168.0.254 (xid=0x6a15c2ea)Aug 15 17:18:44 localhost dhclient[3412]: bound to 192.168.0.89 -- renewal in 1563 seconds.Aug 15 17:18:44 localhost NetworkManager[2290]: (em1): DHCPv4 state changed bound -> renewAug 15 17:18:44 localhost NetworkManager[2290]: address 192.168.0.89Aug 15 17:18:44 localhost NetworkManager[2290]: prefix 24 (255.255.255.0)Aug 15 17:18:44 localhost NetworkManager[2290]: gateway 192.168.0.254Aug 15 17:18:44 localhost NetworkManager[2290]: nameserver '114.114.114.114'Aug 15 17:24:39 localhost dbus: avc: received setenforce notice (enforcing=0)Aug 15 17:24:39 localhost dbus: avc: received setenforce notice (enforcing=0)Aug 15 17:44:47 localhost dhclient[3412]: DHCPREQUEST on em1 to 192.168.0.254 port 67 (xid=0x6a15c2ea)Aug 15 17:44:47 localhost dhclient[3412]: DHCPACK from 192.168.0.254 (xid=0x6a15c2ea)Aug 15 17:44:47 localhost dhclient[3412]: bound to 192.168.0.89 -- renewal in 1713 seconds.Aug 15 17:44:47 localhost NetworkManager[2290]: (em1): DHCPv4 state changed renew -> renewAug 15 17:44:47 localhost NetworkManager[2290]:address 192.168.0.89Aug 15 17:44:47 localhost NetworkManager[2290]: prefix 24 (255.255.255.0)Aug 15 17:44:47 localhost NetworkManager[2290]: gateway 192.168.0.254Aug 15 17:44:47 localhost NetworkManager[2290]: nameserver '114.114.114.114'Aug 15 18:13:20 localhost dhclient[3412]: DHCPREQUEST on em1 to 192.168.0.254 port 67 (xid=0x6a15c2ea)Aug 15 18:13:20 localhost dhclient[3412]: DHCPACK from 192.168.0.254 (xid=0x6a15c2ea)Aug 15 18:13:20 localhost dhclient[3412]: bound to 192.168.0.89 -- renewal in 1607 seconds.Aug 15 18:13:20 localhost NetworkManager[2290]: (em1): DHCPv4 state changed renew -> renewAug 15 18:13:20 localhost NetworkManager[2290]: address 192.168.0.89Aug 15 18:13:20 localhost NetworkManager[2290]: prefix 24 (255.255.255.0)Aug 15 18:13:20 localhost NetworkManager[2290]: gateway 192.168.0.254Aug 15 18:13:20 localhost NetworkManager[2290]: nameserver '114.114.114.114'10、竟然是因为旧版的数据库⽂件导致的错误，（默认旧版会⽣成⼀些数据库⽂件，升级完成后新版数据库启动时会读取旧版数据库的⽂件，故⽽导致数据库启动失败）。
Centos6.8Mysql5.6安装配置教程
Centos6.8Mysql5.6安装配置教程MySQL是⼀个关系型数据库管理系统，由瑞典MySQL AB 公司开发，⽬前属于 Oracle 旗下产品。
MySQL 最流⾏的关系型数据库管理系统，在 WEB 应⽤⽅⾯MySQL是最好的 RDBMS (Relational Database Management System，关系数据库管理系统) 应⽤软件之⼀。
⼯具/原料Centos6.8Mysql5.6⽅法/步骤1. 1准备Mysql⽂件：⽅式⼀：wget url（mysql下载地址）;⽅式⼆：从官⽹下载mysql，上传⾄centos（⼩编使⽤的Nodepad++的NppFTP具体做法请百度）;2. 2检查之前安装版本与卸载：1：检查之前版本；rpm -qa | grep -i mysql2：卸载之前安装所有；yum -y remove mysql-libs*3. 3安装与初始化：1：安装；rpm -ivh MySQL-server-5.6.34-1.rhel5.x86_64.rpmrpm -ivh MySQL-client-5.6.34-1.rhel5.x86_64.rpmrpm -ivh MySQL-devel-5.6.34-1.rhel5.x86_64.rpm2：初始化；cp /usr/share/mysql/f /etc/f/usr/bin/mysql_install_db4. 4修改ROOT密码：1：启动；service mysql start2：查看默认密码；cat /root/.mysql_secret3：默认密码登录；mysql -u root -pM5kgMmUWlVtyKaHC4：设置密码；SET PASSWORD = PASSWORD('root');5：⽣效；flush privileges;5. 5远程访问授权：use mysql;select host,user,password from user;update user set password=password('root') where user='root';update user set host='%' where user='root' and host='localhost';flush privileges;exit6. 6mysql 配置：1：编辑配置⽂件；vi /etc/f2：修改配置如下；[client]password = 123456port = 3306default-character-set=utf8[mysqld]port = 3306character_set_server=utf8character_set_client=utf8collation-server=utf8_general_ci#(注意linux下mysql安装完后是默认：表名区分⼤⼩写，列名不区分⼤⼩写； 0：区分⼤⼩写，1：不区分⼤⼩写) lower_case_table_names=1#(设置最⼤连接数，默认为 151，MySQL服务器允许的最⼤连接数16384; )max_connections=1000[mysql]default-character-set = utf8socket = /var/lib/mysql/mysql.sock3：重启mysql；service mysql restart7. 7设置开机启动：1：开机启动；chkconfig mysql on2：查看；chkconfig --list | grep mysqlEND注意事项须具备⼀定linux经验！⽀持⼩编，请投上⼀票！。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
CENTOS6 下编译安装MYSQL 5.6.26
CentOS6下通过yum安装的MySQL是5.1版的，比较老，所以就想通过源代码安装高版本的5.6.26。
一：卸载旧版本
使用下面的命令检查是否安装有MySQL Server
rpm -qa | grep mysql
有的话通过下面的命令来卸载掉
rpm -e mysql // 普通删除模式
rpm -e --nodeps mysql // 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除
二、安装编译MySQL需要的工具
安装g++和gdb
yum install gcc-c++
yum install gdb
安装cmake
yum install cmake
安装ncurses
yum install ncurses-devel
安装bison
yum install bison bison-devel
编译依赖的工具说明请参考/doc/refman/5.6/en/source-installation.html
三、安装MySQL
1）参考以下两个链接下载MySQL 5.6.26
/doc/refman/5.6/en/getting-mysql.html
/downloads/mirrors.html
下载完成后解压
tar xvf mysql-5.6.26.tar.gz
cd mysql-5.6.26
2）编译安装
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
make
make install
编译的参数请参考/doc/refman/5.6/en/source-configuration-options.html 编译过程需要30分钟左右，编译并安装完成后可以看一下结果
ll /usr/local/mysql
四、配置MySQL
1）配置用户
使用下面的命令查看是否有mysql用户及用户组
cat /etc/passwd 查看用户列表
cat /etc/group 查看用户组列表
如果没有就创建
#groupadd mysql
#useradd -r -g mysql mysql
确认一下创建结果
id mysql
修改/usr/local/mysql目录权限
chown -R mysql:mysql /usr/local/mysql
2）初始化配置
安装运行MySQL测试脚本需要的perl
yum install perl
进入安装路径
cd /usr/local/mysql
执行初始化配置脚本，创建系统自带的数据库和表
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql 注：在启动MySQL服务时，会按照一定次序搜索f，先在/etc目录下找，找不到则会搜索"$basedir/f"，在本例中就是/usr/local/mysql/f，这是新版MySQL的配置文件的默认位置！
注意：在CentOS 6.4版操作系统的最小安装完成后，在/etc目录下会存在一个f，需要将此文件更名为其他的名字，如：/etc/f.bak，否则，该文件会干扰源码安装的MySQL 的正确配置，造成无法启动。
在使用"yum update"更新系统后，需要检查下/etc目录下是否会多出一个f，如果多出，将它重命名成别的。
否则，MySQL将使用这个配置文件启动，可能造成无法正常启动等问题。
3）启动MySQL
添加服务，拷贝服务脚本到init.d目录，并设置开机启动
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service mysql start --启动MySQL
4）配置MySQL账号密码
MySQL启动成功后，root默认没有密码，我们需要设置root密码。
设置之前，我们需要先设置PA TH，要不不能直接调用mysql
修改/etc/profile文件，在文件末尾添加
PATH=/usr/local/mysql/bin:$PA TH
export PA TH
关闭文件，运行下面的命令，让配置立即生效
source /etc/profile
现在，我们可以在终端内直接输入mysql进入，mysql的环境了
执行下面的命令修改root密码
mysql -uroot
mysql> SET PASSWORD = PASSWORD('123456');
若要设置root用户可以远程访问，执行
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
远程访问时的密码可以和本地不同。
5）配置防火墙
防火墙的3306端口默认没有开启，若要远程访问，需要开启这个端口
打开/etc/sysconfig/iptables
在“-A INPUT –m state --state NEW –m tcp –p –dport 22 –j ACCEPT”，下添加：
-A INPUT -m state --state NEW -m tcp -p -dport 3306 -j ACCEPT
然后保存，并关闭该文件，在终端内运行下面的命令，刷新防火墙配置：
service iptables restart
一切配置完毕，你就可以访问MySQL了。