【分享】Linux 源码安装Mysql5.5

wwm

[ 本帖最后由 cenalulu 于 2012-12-17 11:24 编辑 ]

<p>1、从[url]http://blog.s135.com/soft/linux/nginx_php/mysql/mysql-5.5.2-m2.tar.gz[/url] 下载源码安装包到/usr/local/src</p>
<p>2、tar zxvf mysql-5.5.2-m2.tar.gz 解压到/usr/local/src/mysql-5.5.2-m2下</p>
<p>&nbsp;&nbsp;&nbsp; cd mysql-5.5.2-m2/</p>
<p>&nbsp;&nbsp;&nbsp; ./configure --prefix=/home/mysql/ --enable-assembler
--with-extra-charsets=complex --enable-thread-safe-client
--with-big-tables --with-readline --with-ssl --with-embedded-server
--enable-local-infile --with-plugins=partition,innobase,myisammrg</p>
<p>&nbsp;&nbsp; （在另外一台服务器安装时，出现configure: error: No curses/termcap library
found错误，加上--with-named-curses-libs=/usr/lib/libncursesw.so.5参数可以解决，或者再用
yum安装ncurses-devel也可）</p>
<p>&nbsp;&nbsp;&nbsp; make</p>
<p>&nbsp;&nbsp;&nbsp; make install</p>
<p>&nbsp;&nbsp;&nbsp; 在make install的后半过程，有一段比较长时间的停顿，不要担心死掉了，实际上它还活着，耐心的等待，最终会安装完毕。</p>
<p>3、如果还没有mysql用户，创建：</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; groupadd mysql</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; useradd mysql -g mysql</p>
<p>4、修改目录权限：</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; chmod +w /home/mysql<br>
&nbsp;&nbsp;&nbsp;&nbsp; chown -R mysql:mysql /home/mysql</p>
<p>5、创建数据目录（mysql5.5默认已经没有data目录了）</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; mkdir /home/mysql/data</p>
<p>6、初始化数据库：</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; /home/mysql/bin/mysql_install_db --basedir=/home/mysql --datadir=/home/mysql/data --user=mysql</p>
<p>7、创建mysql配置文件：/etc/my.cnf</p>
<p>&nbsp;&nbsp;&nbsp;&nbsp; [mysqld]<br>
datadir=/home/mysql/data<br>
socket=/tmp/mysql.sock<br>
user=mysql<br>
<br>
log=/home/mysql/sql.log<br>
log_slow_queries=ON<br>
log_slow_queries=/home/mysql/sql_slow.log<br>
long_query_time=2<br>
<br>
[client]<br>
port&nbsp;&nbsp;&nbsp; = 3306<br>
socket&nbsp; = /tmp/mysql.sock</p>
<p>8、启动mysql</p>
<p>&nbsp;&nbsp;&nbsp; /home/mysql/bin/mysqld_safe &amp;</p>