Cetos编译安装MySQL5.6

来源：互联网发布：朗诵配乐知乎编辑：程序博客网时间：2024/06/09 15:14

卸载旧版本

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.gztar xvf mysql-5.6.16.tar.gzcd 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/mysqlchown -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/mysqldvim /etc/profilePATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATHexport PATH

source /etc/profile

8. 启动

service mysqld start

9. 检查是否启动

netstat -tulnp | grep 3306mysql -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

问题解决

0 0