二进制mysql的安装过程详解:
#groupadd -r -g 306 mysql
#useradd -g 306 -r -u 306 mysql
#tar -xf mysql-5.5.28-linux2.6-i686.tar.gz -C /usr/local
#cd /usr/local
#ln -sv mysql-5.5.28-linux2.6-i686 mysql
#chown -R mysql.mysql /usr/local/mysql/*
#cd /usr/local/mysql/scripts/
#./mysql_install_db --user=mysql --datadir=/mydata/data
#chown -R root /usr/local/mysql/*
#cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
#chkconfig --add mysqld
#chkconfig --list mysqld
处理配置文件:
#cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
编辑/etc/my.cnf,在mysqld节中增加 datadir = /mydata/data
/etc/my.cnf
/etc/mysql/my.cnf
$BASEDIR/my.cnf
~/.my.cnf
如果四个配置文件存在冲突,以最后的配置文件中的值为准。
#service mysqld start