centos 6.4_x86安装5.1.x
环境
[root@lvs-backup ~]# cat /etc/issue
CentOS release 6.4 (Final)
Kernel \r on an \m
[root@lvs-backup ~]# uname -a
Linux lvs-backup 2.6.32-358.el6.x86_64
mysql5.1x简体中文手册地址
http://doc.mysql.cn/mysql5/refman-5.1-zh.html-chapter/
安装
useradd -s /sbin/nologin -M mysql
cd /usr/local/src/
wget http://down1.chinaunix.net/distfiles/mysql-5.1.58.tar.gz
tar fxz mysql-5.1.58.tar.gz
cd mysql-5.1.58
./configure \
--prefix=/usr/local/mysql \
--enable-assembler \
--with-big-tables \
--with-charset=utf8 \
--with-extra-charsets=all \
--with-plugins=all
make && make install
配置
创建数据目录
mkdir /data/mysql -p
chown mysql.mysql /data/mysql/ -R
初始化数据库
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
设置mysql客户端变量
[mysql]
prompt="(\u:\h:)[\d]> "
no-auto-rehash
配置my.cnf文件
启动数据库
/usr/local/mysql/bin/mysqld_safe --defaults-file=/usr/local/mysql/etc/my.cnf --user=mysql &