CentOS 6.5下源码安装 mysql 5.6.23

groupadd mysql
useradd mysql -g mysql -M -s /sbin/nologin

wget http://download.softagency.net/MySQL/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz

tar zxvf mysql-5.6.23.tar.gz

cmake -DCMAKE_INSTALL_PREFIX=/home/soft/mysql -DMYSQL_DATADIR=/home/soft/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/mysqld.sock -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

cd /home/soft/mysql   
chown -R mysql:mysql .
scripts/mysql_install_db --user=mysql --datadir=/home/soft/mysql/data --basedir=/home/soft/mysql
chown -R root:mysql .
chown -R mysql:mysql ./data

cp /home/soft/mysql/support-files/my-default.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysqld
chkconfig mysqld on   &&     chkconfig --add mysql

修改my.cnf配置
    vim /etc/my.cnf
     
    #[mysqld] 添加：
    datadir=/data/mysql
    default-storage-engine=MyISAM

/etc/init.d/mysqld start  &&  service mysqld start

vim /etc/profile
PATH=/home/soft/mysql/bin:$PATH
export PATH

source /etc/profile

设置密码：
mysql -uroot  
mysql> SET PASSWORD = PASSWORD('123456');

&&   mysqladmin -u root password '123456'
 

--- 可能存在的问题 ---


    问题：   
    Starting MySQL..The server quit without updating PID file ([FAILED]/mysql/Server03.mylinux.com.pid).   
    解决：   
    修改/etc/my.cnf 中datadir,指向正确的mysql数据库文件目录  


     问题：   
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)   
    解决：   
    新建一个链接或在mysql中加入-S参数，直接指出mysql.sock位置。   
    ln -s /home/soft/mysql/data/mysql.sock /tmp/mysql.sock   
 
    /home/soft/mysql/bin/mysql -u root -S /home/soft/mysql/data/mysql.sock