Linux下安装mysql 5.0.56

 

1. 下载并解包
将网络下载的mysql-5.0.56.tar.gz文件放在/usr/local/src目录并解包

# cd /usr/local/src
# tar xzvf mysql-5.0.56.tar.gz
# cd mysql-5.0.56

2. 编译安装

#./configure
--prefix=/usr/local/mysql
--localstatedir=/var/lib/mysql
--with-comment=Source
--with-server-suffix=-enterprise-gpl
--with-mysqld-user=mysql
--without-debug
--with-big-tables
--with-charset=utf8
--with-collation=utf8_general_ci
--with-extra-charsets=all
--with-pthread
--enable-static
--enable-thread-safe-client
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
--enable-assembler
--without-innodb
--without-ndb-debug
--without-isam
--enable-local-infile
--with-readline
--with-raid
如果编译成功，你会看到：Thank you for choosing MySQL!

#make
在此过程中遇到"/usr/bin/ld: cannot find -lncurses"错误，安装libncurses5-dev包后再次编译正常。
#make install
安装完成
3. MYSQL配置
# groupadd mysql
# useradd -g mysql -s /bin/false -M mysql
# cd /usr/local/mysql
#bin/mysql_install_db --user=mysql
安装MYSQL系统表

Installing MySQL system tables...
OK
Filling help tables...
OK
......

设置目录文件权限
# chown -R root:mysql .
# chown -R mysql /var/lib/mysql
# chgrp -R mysql .
# cp share/mysql/my-medium.cnf /etc/my.cnf
# cp share/mysql/mysql.server /etc/rc.d/init.d/mysqld
# chmod 755 /etc/rc.d/init.d/mysqld
加入自动启动服务队列
# chkconfig --add mysqld
配置库文件搜索路径
# echo "/usr/local/mysql/lib" >> /etc/ld.so.conf && ldconfig
开启或关闭mysqld服务
/etc/rc.d/init.d/ mysqld start/stop
service mysqld start/stop
修改root初始密码
bin/ mysqladmin -u root password "your password"
4. 安装完成