Linux 基于源码的mysql安装

在上一篇文章中，讲到mysql的卸载，这里谈谈mysql基于源码的安装。

1、myql下载

[root@linux download]# wget -c http://mirror.provenscaling.com/mysql/community/source/5.1/mysql-5.1.28-rc.tar.gz

2、解压缩

[root@linux download]# tar -zxvf mysql-5.1.28-rc

3、编译安装

[root@linux mysql-5.1.28-rc]# cd mysql-5.1.28-rc
[root@linux mysql-5.1.28-rc]# ./configure --prefix=/usr/local/mysql --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-charset=utf8  --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile

配置的具体意义，可以通过./configure --help 获取帮助

[root@linux mysql-5.1.28-rc]# make && make install

4、添加用户/组

[root@linux mysql-5.1.28-rc]# groupadd mysql
[root@linux mysql-5.1.28-rc]# useradd -s /sbin/nologin -M -g mysql mysql

5、编辑配置文件my.cnf

[root@linux ~]# cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
[root@linux ~]# sed -i 's/skip-locking/skip-external-locking/g' /etc/my.cnf

6、安装数据库

[root@linux ~]# /usr/local/mysql/bin/mysql_install_db --user=mysql

7、设置文件宿主

[root@linux ~]# chown -R mysql /usr/local/mysql/var
[root@linux ~]# chgrp -R mysql /usr/local/mysql/.

8、设置服务

[root@linux ~]# cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysql
[root@linux ~]# chmod 755 /etc/init.d/mysql
[root@linux ~]# chkconfig --level 345 mysql on

[root@linux ~]# cat > /etc/ld.so.conf.d/mysql.conf<<EOF
> /usr/local/mysql/lib/mysql
> /usr/local/lib
> EOF
[root@linux ~]# ldconfig

[root@linux ~]# ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql 
[root@linux ~]# ln -s /usr/local/mysql/include/mysql /usr/include/mysql

9、启动服务

[root@linux ~]# /etc/init.d/mysql start
或
[root@linux ~]# service mysql start

10、设置为开机自启动

[root@localhost ~]# cat >> /etc/rc.d/rc.local 
/etc/init.d/mysql start

11、设置符号链接

[root@linux ~]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@linux ~]# ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump
[root@linux ~]# ln -s /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk

12.设置密码

[root@linux ~]# /usr/local/mysql/bin/mysqladmin -u root password 12345
[root@linux ~]# /etc/init.d/mysql restart