MySQL 5.5.x 编译安装-优快云博客

本文详细介绍了在CentOS6.5环境下MySQL5.5.x版本的编译安装过程，包括环境准备、依赖安装、源码编译、配置文件及启动脚本创建等步骤，并提供了安全设置建议。

2019独角兽企业重金招聘Python工程师标准>>>

<h2 style="-webkit-print-color-adjust: exact; margin-right: 0px; margin-bottom: 10px; margin-left: 0px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #cccccc; font-family: Helvetica, arial, sans-serif; margin-top: 0px !important;">MySQL 5.5.x 编译安装</h2> <blockquote style="-webkit-print-color-adjust: exact; margin: 15px 0px; border-left-color: #dddddd; padding: 0px 15px; color: #777777; font-family: Helvetica, arial, sans-serif; font-size: 14px; line-height: 22px;"> <p style="-webkit-print-color-adjust: exact; margin: 0px;">最近开始学习重新整理一遍MySQL的相关知识，以前总是零零散散的学习，现在重新整理一遍，文章当做自己的笔记</p> </blockquote> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">系统环境</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">Distribution : CentOS 6.5 minimal <br />MySQL version : 5.5.38 <br />Init system : sysvinit</code></pre> <p>1、添加用户组</p> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">useradd -r mysql <br />groupadd -r mysql </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">2、新建数据目录</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">mkdir -p /mydata/data <br />chown -R mysql.mysql /mydata/data/ </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">3、安装依赖</h5> <blockquote style="-webkit-print-color-adjust: exact; margin: 15px 0px; border-left-color: #dddddd; padding: 0px 15px; color: #777777; font-family: Helvetica, arial, sans-serif; font-size: 14px; line-height: 22px;"> <p style="-webkit-print-color-adjust: exact; margin: 0px;">之所以安装了openssl-devel是因为下面开启了ssl验证，不安装的话编译不通过，其余的包是官方给出所需要最少需要的包，这里全部安装上</p> </blockquote> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">yum install gcc gcc-c++ cmake ncurses-devel openssl-devel bison-devel libaio -y</code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">4、获取源码包</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.38.tar.gz <br />#wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.16.tar.gz </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">5、解压缩安装</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">tar zxf mysql-5.5.38.tar.gz <br />cd mysql-5.5.38 <br />cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \<br /> -DMYSQL_DATADIR=/mydata/data \ <br /> -DSYSCONFDIR=/etc \ <br /> -DWITH_INNOBASE_STORAGE_ENGINE=1 \<br /> -DWITH_ARCHIVE_STORAGE_ENGINE=1 \<br /> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \<br /> -DWITH_READLINE=1 \<br /> -DWITH_SSL=system \<br /> -DWITH_ZLIB=system \<br /> -DWITH_LIBWRAP=0 \<br /> -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \<br /> -DDEFAULT_CHARSET=utf8 \<br /> -DDEFAULT_COLLATION=utf8_general_ci <br />make <br />make install </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">6、生成配置文件，启动脚本，初始化工作</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">chown -R .mysql /usr/local/mysql/ <br />cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf <br /><br />在[mysql]中加入 <br />datadir = /mydata/data </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">7、初始化库，加入开机启动</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">/usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/mydata/data/ <br />cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld <br />chmod +x /etc/init.d/mysqld <br />chkconfig --add mysqld <br />/etc/init.d/mysqld start </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">8、增加PATH标量</h5> <pre style="-webkit-print-color-adjust: exact; margin: 15px 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">vim /etc/profile.d/mysql.sh <br />export PATH=/usr/local/mysql/bin:$PATH source /etc/profile.d/mysql.sh </code></pre> <h5 style="-webkit-print-color-adjust: exact; margin: 20px 0px 10px; padding: 0px; -webkit-font-smoothing: antialiased; cursor: text; position: relative; font-size: 14px; font-family: Helvetica, arial, sans-serif; line-height: 22px;">9、简单的安全工作</h5> <pre style="-webkit-print-color-adjust: exact; margin-top: 15px; margin-right: 0px; margin-left: 0px; background-color: #f8f8f8; border: 1px solid #cccccc; font-size: 13px; line-height: 19px; overflow: auto; padding: 6px 10px; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px; margin-bottom: 0px !important;"><code style="-webkit-print-color-adjust: exact; margin: 0px; padding: 0px; border: none; background-color: transparent; border-top-left-radius: 3px; border-top-right-radius: 3px; border-bottom-right-radius: 3px; border-bottom-left-radius: 3px;">删除匿名用户 <br />mysql> drop user ''@localhost; <br />mysql> drop user ''@node128; \\这里我的测试机hostname <br />mysql> drop user root@'::1'; <br /><br />修改root密码 <br />mysql> update user set password=PASSWORD('********') where user='root'; <br />mysql> flush privileges; mysql> \q</code></pre> <p>安装完成之后下面开始从基本的一些之前一些学习的总结</p>

转载于:https://my.oschina.net/songmingming/blog/266147