CentOS5下MySQL源码安装方式

CentOS5下MySQL源码安装方式

1、编译环境安装

uname -a

Linux ha01 2.6.18-194.el5 #1 SMP Fri Apr 2 14:58:35 EDT 2010 i686 i686 i386 GNU/Linux

yum -y install gcc

yum install -y gcc-c++

2、mysql编译安装

[root@ha01 local]# tar -xvf mysql-5.1.54.tar.gz

[root@ha01 local]# groupadd mysql
[root@ha01 local]# useradd -g mysql mysql
[root@ha01 local]# ./configure  --prefix=/usr/local/mysql  --with-named-curses-libs=/usr/lib/libncursesw.so.5

[root@ha01 local]# cd mysql-5.1.54

[root@ha01 mysql-5.1.54]# make

[root@ha01 mysql-5.1.54]# make install
[root@ha01 mysql-5.1.54]# cp support-files/my-medium.cnf /etc/my.cnf

[root@ha01 mysql-5.1.54]# cp support-files/mysql.server /etc/init.d/mysql

[root@ha01 mysql-5.1.54]# chmod +x /etc/init.d/mysql

[root@ha01 mysql-5.1.54]# chkconfig --add mysql

[root@ha01 mysql-5.1.54]# cd /usr/local/mysql

[root@ha01 mysql]# bin/mysql_install_db --user=mysql

[root@ha01 mysql]# chown -R root .

[root@ha01 mysql]# chown -R mysql var
[root@ha01 mysql]# chgrp -R mysql .

[root@ha01 mysql]# bin/mysqld_safe --user/mysql &

[root@ha01 mysql]# ./bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.54-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.01 sec)

3、启停服务

[root@ha01 mysql-5.1.54]# /etc/init.d/mysql stop
Shutting down MySQL.           [确定]
[root@ha01 mysql-5.1.54]# /etc/init.d/mysql start
Starting MySQL.                 [确定]