编译安装mysql

创建MySQL用户

useradd –s /sbin/nologin –g mysql –M mysql

解压缩二进制安装MySQL

tar xf mysql-5.5.32-linux2.6-x86_64.tar.gz
mv mysql-5.5.32-linux2.6-x86_64 mysql
chown mysql.mysql -R mysql/
cd mysql    cd scripts/
./mysql_install_db  --basedir=/application/mysql/ --datadir=/applicationl/data/ --user=mysql
cp ../support-files/my-small.cnf /etc/my.cnf
cp ../support-files/mysql.server /etc/init.d/mysqld

由于二进制安装目录是/application/mysql,所以需要更改目录

然后设置环境变量并使其生效

vi /etc/init.d/mysqld   vi /application/mysql/bin/mysqld_safe
:%s#/usr/local/mysql#/application/mysql#g
echo ‘export PATH=/application/mysql/bin:$PATH’ >>/etc/profile
sourse /etc/profile

MySQL安全配置,给root用户设置密码

mysqladmin –u root password ‘000000’