安装编译工具和cmake和bison
[root@db mysql-5.5.22]# yum install gcc gcc-c++ ncurses-devel cmake bison
编译安装MySQL
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
cd /tmp
tar xvf mysql-5.5.22.tar.gz
mkdir -p /usr/local/mysql #基本目录
mkdir -p /home/mysql/data #数据目录
cd mysql-5.5.22/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_DATADIR=/home/mysql/data -DMYSQL_USER=mysql
make
make install
详细编译参数参考:http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html
一些相关设置
chmod +w /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18
4. cd support-files/
5. cp my-large.cnf /var/mysql/my.cnf
6. cp mysql.server /etc/rc.d/init.d/mysqld
更新环境变量
vim /etc/profile 添加
export PATH=$PATH:/usr/local/mysql/bin
初始化:
./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/home/mysql/data/ --user=mysql
chmod +x /etc/init.d/mysql
vi /etc/init.d/mysql(编辑此文件,查找并修改以下变量内容:)
basedir=/usr/local/mysql
datadir=/home/mysql/data
加入启动项:
chkconfig --add mysql
chkconfig mysql on
启动服务:
service mysql start
mysql>
设置密码
mysql -uroot -p1
3306通过防火墙访问
1. 在/etc/sysconfig/iptables里添加
# vi /etc/sysconfig/iptables
添加一条配置规则,如要想开放3306的端口,如下所示:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
2.重启iptables
# /etc/init.d/iptables restart
报错信息:
CMake Error at configure.cmake:152 (LIST):
解决办法:删除CmakeCache.txt