#--------------------------------------#
# create by xk
# by 2014-3-27
# 运维社区
#-------------------------------------#
硬件环境:
华为 RH2288H v2
CPU:E52620 6core
MEM: 32G
系统环境:
CentOS 6.4
MySQL:MySQL 5.6.16
一、安装MySQL
#安装编译代码需要的包
yum -y install make gcc-c++ cmake bison-devel ncurses-devel
cd /home/xuekun/tools
tar xvf mysql-5.6.16.tar.gzcd mysql-5.6.16
cmake \
-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
make && make install
二、安装和配置MySQL
#创建mysql用户
groupadd mysql
useradd -g mysql mysql
#修改/usr/local/mysql权限
chown -R mysql:mysql /usr/local/mysql
#初始化配置脚本,创建系统自带的数据库和表
cd /usr/local/mysql
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
#设置开机启动
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service mysql start #启动MySQL
#配置环境变量
#修改/etc/profile文件,在文件末尾添加
PATH=/usr/local/mysql/bin:$PATH
export PATH
source /etc/profile
#修改mysql root密码
mysql -uroot
mysql> SET PASSWORD = PASSWORD('12qwaszx');
三、FAQ
1、报pid的错误:
service mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/v1.vlix.org.pid).
解决方法:将/etc/my.cnf 删除即可,这样mysql启动就用根据安装是的环境变量来启动
至此,mysql 5.6.16安装完毕,希望对各位博友有所帮助,谢谢!