linux安装mysql5.6Linux：Centos1。首先检查系统是否安装了旧版本的MySQL，使用以下命令：rpm-qa|grepmysql是的话用下面命令卸载rpm-e--nodeps上一步显示mysql的名字安装编译mysql需要的依赖包yuminstalllibevent*libtool*autoconf*libstd*ncurse*bison*openssl*yum-yinstallgccgcc-c++2.安装cmake，mysql5.5以后需要使用cmake支持编译安装，下载安装cmakewgethttp://www.cmake.org/files/v2.8/cmake-2.8.12.1.tar.gztar-xfcmake-2.8.12.1.tar.gzcdcmake-2.8.12.1./configure&&make&&makeinstall查看cmake是否安装cmake--version3.下载mysqlwgethttp://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14.tar.gztarxvfmysql-5.6.14.tar如果.gzcdmysql-5.6.14下载失败，可以在这里下载：http://download.csdn.net/deta...或者百度网盘下载：https://pan.baidu.com/s/1kVwRD2Z4.编译安装cmake-DCMAKE_INSTALL_PREFIX=/usr/本地/mysql-DMYSQL_DATADIR=/usr/local/mysql/data-DSYSCONFDIR=/etc-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock_DMSQL_TCP_DMRT=3306-DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_cimake&&makeinstall如果在上面的编译报错，CouldNOTfindCurses(missing:CURSES_LIBRARYCURSES_INCLUDE_PATH)，则使用下面的编辑代码:cmake-DCURSES_LIBRARY=/usr/lib/libncurses.so-DCURSES_INCLUDE_PATH=/usr/include-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/usr/local/mysql/data-DSYSCONFDIR=/etc-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock-DMYSQL_TCP_PORT=3306-DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci要很等了半天，我在虚拟机里安装了双核2G内存，大概用了20分钟。另外可能会遇到如下错误：1.yuminstalllibevent*libtool*autoconf*libstd*ncurse*bison*openssl*报错：libevent2-develconflictswithlibevent-devel-1.4.13-4.el6.x86_64then执行：yuminstalllibevent2libtool*autoconf*libstd*ncurse*bison*openssl*2.查看ls/usr/lib/libncurses.so如果没有找到，再找/-name'libncurses.so'我找到的文件如下：/usr/lib64/libncurses.so添加快捷方式ln-s/usr/lib64/libncurses.so/usr/lib/libncurses.so5.配置mysqlgroupaddmysqluseradd-gmysqlmysqlchown-Rmysql:mysql/usr/local/mysql初始化配置cd/usr/local/mysqlscripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--user=mysql配置自启动并启动mysqlcpsupport-files/mysql。server/etc/init.d/mysqlchkconfigmysqlonservicemysqlstartconfigurePATHvi/etc/profile`#在文件末尾添加PATH=/usr/local/mysql/bin:$PATHexportPATH#保存退出，有效配置源/etc/profile登录mysql并设置root密码mysql-urootmysql>SETPASSWORD=PASSWORD('123456');设置mysql以远程访问mysql>GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'123456'WITHGRANTOPTION;如果是远程，配置可以远程访问，防火墙配置允许3306端口/sbin/iptables-IINPUT-ptcp--dport3306-jACCEPT/etc/rc.d/init.d/iptables保存6。数据库定期备份：mkdir/backupchmod777-R/backupvim/backup/mysql_backup.sh写入如下内容：-p引号为数据库密码，erp为备份数据库名#!/bin/bashdate=$(date+%Y%m%d)/usr/local/mysql/bin/mysqldump-hlocalhost-uroot-p'Ddsd#$#2s$!s4343%$^&s'erp>/backup/databases-$date.sql设置CRON，定时备份：crontab-e0006***/bin/bash/backup/mysql_backup.sh
