mysql5.1.33 源码安装过程

操作系统：SUSE Linux Enterprise Server 10 (i586)

安装源文件：MySQL-community-5.1.33-0.sles10.src.rpm

 

1.groupadd mysql 

2.useradd -g mysql mysql

3.rpm -i MySQL-community-5.1.33-0.sles10.src.rpm

4. cd /usr/src/packages/SOURCES

5.tar -xzvf mysql-5.1.33.tar.gz

6.cd mysql-5.1.33

7. ./configure --prefix=/usr/local/mysql --enable-assembler --with-plugins=max  --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --with-charset=utf8

8.make

9.sudo make install

10. sudo cp support-files/my-medium.cnf /etc/my.cnf

11.cd /usr/local/mysql

12.sudo vi /etc/my.cfg 

     注释掉  skip-federated

13.bin/mysql_install_db --user=mysql   

     初始化数据库

14.bin/mysqladmin -uroot shutdown 

15.sudo vi /etc/my.cfg

[mysqld] 下面添加

default_character_set=utf8

default-storage-engine=innodb
default_character_set=utf8
lower_case_table_names=1
long_query_time=0.17
log-slow-queries= /home/mysql/logs/slowquery.log

16./bin/mysqld_saft &

 

启动成功