环境基于Debian Lenny
1)下载MySQL 5.5的二进制包
wget
https://mirror.yandex.ru/mirrors/ftp.mysql.com/Downloads/MySQL-5.5/mysql-5.5.3-m3-linux2.6-i686.tar.gz
tar zxvf mysql-5.5.3-m3-linux2.6-i686.tar.gz -C
mv /var/mysql-5.5.3-m3-linux2.6-i686 /var/mysql
chown -R root.root /var/mysql
cp /var/mysql/support-files/my-medium.cnf /etc/my.cnf
cp /var/mysql/support-files/mysql.server /etc/init.d/mysql
2)编辑/etc/my.cnf
在[mysqld]段下添加
basedir = /var/mysql
datadir = /var/mysql/data
skip-name-resolve
log-error = /var/mysql/logs/mysql.err
pid-file = /var/run/mysql.pid
log = /var/mysql/logs/mysql.log
将
log-bin=mysql-bin
binlog_format=mixed
注释掉
PS:如果要设置client和server端的数据库编码，需要新添加
[msyql]
default-character-set = utf8
在[mysqld]段里添加：character-set-server = utf8
3)执行mysql_install_db
/var/mysql/scripts/mysql_install_db –basedir=/var/mysql –datadir=/var/mysql/data –user=root
4)设置数据库root用户密码
/var/mysql/bin/mysqladmin -u root password password //斜体部分为需要设置的密码
5)启动数据库
/etc/init.d/mysql start –user=root
6)编辑环境变量，将/var/mysql/bin，添加到系统变量中
vi /etc/profile
将
if [ "`id -u`" -eq 0 ]; then
PATH=”/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin”
else
PATH=”/usr/local/bin:/usr/bin:/bin:/usr/games”
fi
改为
if [ "`id -u`" -eq 0 ]; then
PATH=”/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/var/mysql/bin”
else
PATH=”/usr/local/bin:/usr/bin:/bin:/usr/games”
fi
保存后，执行source /etc/profile
，让配置立马生效
PS: 如果在my.cnf中指定了socket = /var/mysql/tmp/mysql.sock，在登录MySQL时，需要指定socket的路径,例如：
mysql -uroot -p -S /var/mysql/tmp/mysql.sock
