MySQL 源码安装

[bash]
groupadd mysql
useradd -g mysql mysql
tar zxvf mysql-*.**.**.tar.gz
cd mysql-*.**.**
./configure --prefix=/usr/local/mysql
make
make install
scripts/mysql_install_db
chown -r root /usr/local/mysql
chown -r mysql /usr/local/mysql/var
chgrp -r mysql /usr/local/mysql
cp support-files/my-medium.cnf /etc/my.cnf
cp scripts /usr/local/mysql -r
cp support-files /usr/local/mysql -r
cd /usr/local/mysql
chmod +x support-files/mysql.server
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
[/bash]

设置 MySQL 开机自动运行:
[bash]
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/mysqld
echo "/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf &" >> /etc/rc.d/rc.local
/etc/rc.d/init.d/mysqld start
[/bash]

MySQL 客户端
[bash]
/usr/local/mysql/bin/mysqladmin -u root -p
[/bash]


TIPS: 忘记密码时启动
[bash]
safe_mysqld --skip-grant-tables
[/bash]