在linux下的编译和安装mysql

[i=s] 本帖最后由 longyun 于 2010-1-27 22:55 编辑 [/i]

在linux下的编译和安装mysql


方法一：

[root@localhost mtd]# mkdir /usr/local/mysql
[root@localhost mtd]# cp mysql-5.1.42-2.tar.gz /home/
[root@localhost root]# cd /home/
解压
[root@localhost home]# tar zxvf mysql-5.1.42-2.tar.gz
[root@localhost home]# cd mysql-5.1.42-2
配置，生成Makefile
[root@localhost mysql-5.1.42-2]# ./configure --prefix=/usr/local/mysql --without-debug --with-extra-charsets=gb2312 --enable-assembler --without-isam --without-innodb --with-pthread --enable-thread-safe-client
编译
[root@localhost mysql-5.1.42-2]# make
安装
[root@localhost mysql-5.1.42-2]# make install

[root@localhost mysql-5.1.42-2]# scripts/mysql_install_db

创建一个数据库管理员
[root@localhost mysql-5.1.42-2]# groupadd mysql
[root@localhost mysql-5.1.42-2]# useradd -g mysql mysql


改变权限。
[root@localhost mysql]# chown -R root /usr/local/mysql
[root@localhost mysql]# chown -R mysql /usr/local/mysql/var
[root@localhost mysql]# chgrp -R mysql /usr/local/mysql



配置环境变量，以便于编程
[root@localhost mysql-5.1.42-2]# cd /usr/local/mysql/bin/
[root@localhost bin]# export PATH=$PATH:/usr/local/mysql/bin/
[root@localhost bin]# export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/mysql/lib/mysql/
[root@localhost bin]# env


启动mysql服务器
[root@localhost root]# cd /usr/local/mysql/bin/
[root@localhost bin]# ./mysqld_safe -u mysql&
Starting mysqld daemon with databases from /usr/local/mysql/var
查看是否启动了
[root@localhost root]# pgrep mysql
15931
15950
15951

方法二：

yum install mysql-5.1.42-2.fc11.i586
yum install mysql-libs-5.1.42-2.fc11.i586
yum install mysql-devel-5.1.42-2.fc11.i586
yum install mysql-connector-odbc-5.1.5r1144-4.fc11.i586
yum install mysql-server-5.1.42-2.fc11.i586