mysql5.5.10源码安装教程

[不指定 2011/04/02 09:31 | by admin ]
| |
本内容为原创内容,转载请注明:
本文来自http://blog.gsywx.com

系统为centos5.5 32位,从官方下载mysql-5.5.10.tar.gz源码包
mysql-5.5.10.tar.gz上传到系统中的/soft/目录


cd /soft/
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
tar zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./configure
make
make install
cd ../
  
tar zxvf mysql-5.5.10.tar.gz
cd mysql-5.5.10
cmake . -DCMAKE_INSTALL_PREFIX=/web/mysql/ -DMYSQL_DATADIR=/web/mysql/data -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DWITH_DEBUG=0
make && make install
cd /web/mysql/
cp support-files/mysql.server /etc/init.d/mysqld
groupadd mysql
useradd mysql -g mysql -d /dev/null -s /sbin/nologin
chown -R mysql .
chgrp -R mysql .
chmod 755 /etc/init.d/mysqld
cp support-files/my-medium.cnf /etc/my.cnf
sed -i 's/log-bin=mysql-bin/#log-bin=mysql-bin/g' /etc/my.cnf
sed -i 's/binlog_format=mixed/#binlog_format=mixed/g' /etc/my.cnf
sed -i 's/skip-federated/#skip-federated/g' /etc/my.cnf
sed -i 's/skip-locking/skip-locking\nmax_connections = 1000\nwait_timeout = 5/g' /etc/my.cnf
chkconfig --add mysqld
chkconfig mysqld on
./scripts/mysql_install_db --user=mysql
service mysqld start
./bin/mysqladmin -u root password 123654
./bin/mysql -uroot -p
mysql>use mysql;
mysql>show databases;
mysql>quit;
Tags:
电脑类 | 评论(0) | 引用(0) | 阅读(1297)