卸载旧版本
rpm -qa | grep mysql
</pre><h1><span style="font-family:SimHei">安装新版本</span></h1><div><span style="font-family:SimHei"></span></div><h2><span style="font-family:SimHei">1. 安装编译代码需要的包</span></h2><pre name="code" class="python">yum -y install make gcc-c++ cmake bison-devel ncurses-devel
2. 下载MySQL5.6.16
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.16.tar.gz
tar xvf mysql-5.6.16.tar.gz
cd mysql-5.6.16
3. 编译安装
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
4. 修改mysql安装目录所有者和组
cd /usr/local/mysql
chown -R *:*
5. 初始化mysql数据库
cd /scripts
./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=*
6. mysql服务启动配置文件
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
7. mysql服务启动脚本加到PATH路径
cp support-files/mysql.server /etc/init.d/mysqld
vim /etc/profile
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
source /etc/profile
8. 启动
service mysqld start
9. 检查是否启动
netstat -tulnp | grep 3306
mysql -uroot -p
问题
Starting MySQL.... ERROR! The server quit without updating PID file (/usr/local/mysql/data/root.pid).
网上的解决办法很多,根源是权限。查看错误日志,在data目录下,错误日志 root.err :
cat root.err
2015-04-30 15:36:02 13190 [Note] Plugin 'FEDERATED' is disabled./usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
mysql 在启动时候,无法正常处理plugin.frm文件,解决办法是修改问题文件权限,
chmod -R 777 plugin.frm
重新启动,仍然报这个错误,返回去继续查看错误日志
2015-04-30 15:53:38 13574 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
data目录下的ibdata1文件被是只读模式,无法写入,导致错误,同样适用刚才的办法
chmod -R 777 data/
再重新启动mysql
service mysqld start
问题解决