mysql编译安装

#安装

./configure --prefix=/usr/local/mysql5/

#初始化

./bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql5/db/

#配置my.cnf，确保目录存在

my.cnf

[mysqld]
datadir=/usr/local/mysql5/db
socket=/usr/local/mysql5/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]

log-error=/usr/local/mysql5/log/mysqld.log

pid-file=/usr/local/mysql5/run/mysqld/mysqld.pid

#权限

chown mysql.mysql /usr/local/mysql5/run/mysqld/ -R

chmod 777 /usr/local/mysql5/run/mysqld/ -R

#启动mysql

./bin/mysqld_safe --defaults-file=my.cnf &

#关闭服务

./bin/mysqladmin -h127.0.0.1 shutdown