下载 mysql 包
http://dev.mysql.com/downloads/mysql/
http://download.softagency.net/MySQL/Downloads/MySQL-5.5/
创建mysql安装目录
[root@dianzhui ~]# mkdir /usr/local/mysql5.5.12/
创建 mysql帐号
[root@dianzhui ~]# adduser
……
创建数据目录
[root@dianzhui ~]# mkdir /var/mysql
[root@dianzhui ~]# chown mysql.mysql -R /var/mysql
安装 cmake
用 ports 安装cmake
安装mysql 5.5.9
[root@dianzhui ~]# tar zxvf mysql-5.5.12.tar.gz
[root@dianzhui ~]# cd mysql-5.5.12
[root@dianzhui mysql-5.5.12]# cmake . /
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5.12/ /
-DMYSQL_DATADIR=/var/mysql/
-DMYSQL_UNIX_ADDR=/var/mysql/mysqld.sock /
-DWITH_INNOBASE_STORAGE_ENGINE=1 /
-DENABLED_LOCAL_INFILE=1 /
-DMYSQL_TCP_PORT=3306 /
-DEXTRA_CHARSETS=all /
-DDEFAULT_CHARSET=utf8 /
-DDEFAULT_COLLATION=utf8_general_ci /
-DMYSQL_UNIX_ADDR=/var/mysql/mysql.sock /
-DMYSQL_USER=mysql /
-DWITH_DEBUG=0
注:最好把下面两行去掉,以免编码出错
-DDEFAULT_CHARSET=utf8 /
-DDEFAULT_COLLATION=utf8_general_ci /
[root@dianzhui mysql-5.5.12]# make
[root@dianzhui mysql-5.5.12]# make install
复制配置文件
[root@dianzhui mysql-5.5.12]# cp support-files/my-medium.cnf /usr/local/etc/my.cnf
复制启动脚本
[root@dianzhui mysql-5.5.12]# cp support-files/mysql.server /usr/local/etc/rc.d/mysqld
[root@dianzhui mysql-5.5.12]# chmod 755 /usr/local/etc/rc.d/mysqld
初始化数据库 (进到 安装目录)
[root@dianzhui mysql-5.5.12]# cd /usr/local/mysql5.5.12
[root@dianzhui mysql5.5.12]# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql5.5.12 --datadir=/var/mysql/
启动数据库
[root@dianzhui mysql5.5.12]# /usr/local/etc/rc.d/mysqld start
修改root 密码
[root@kevin mysql5.5.12]# /usr/local/mysql5.5.12/bin/mysqladmin -u root password 'new-password'
谈若启动是发生错误,去数据库目录,去看错误日志
拷贝到环境变量
cp mysql mysqladmin mysqld_safe mysqldump /usr/sbin/
添加启动项文件中
[root@kevin mysql5.5.12]# vim /etc/rc.conf
mysql_enable="yes"
mysql_dbdir="/var/mysql"
参考、猪:
选择配置文件说明:http://www.workle.cn/space.php?uid=1&do=blog&id=336
编译安装mysql 5.5.9:http://crazyming.blog.51cto.com/1048571/510659