CentOS6.0编译安装MySQL5.5.17.docx

CentOS 6.0 编译安装 MySQL 5.5.171.安装相关库文件yum install bisongccgcc-c+ autoconfautomakezlib* libxml*ncurses-devel libtool-ltdl-devel*2.安装cmake wget/files/v2.8/cmake-2.8.6.tar.gztar zxvf cmake-2.8.6.tar.gzcd cmake-2.8.6/./configuregmake gmake install3.设置用户/usr/sbin/groupadd mysql （如果有提示已存在，并不是错误）/usr/sbin/useradd -g mysql mysql （如果有提示已存在，并不是错误）mkdir -p /data/mysqlchown -R mysql:mysql /data/mysql 4.MYSQL 5.5.17wget/get/Downloads/MySQL-5.5/mysql-5.5.17.tar.gz/from/.tw/在解压的mysql-5.5.17目录中移除目录中的CMakeCache.txttar zxvf mysql-5.5.17.tar.gzcd mysql-5.5.17cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc/makemake install5.设置cd /usr/local/mysql cp ./support-files/f /etc/f编辑/etc/f vi /etc/f在 mysqld 段增加datadir = /data/mysqlwait-timeout = 30max_connections = 512max_connect_errors = 10000000default-storage-engine = MyISAM在 mysqld 段修改max_allowed_packet = 16M./scripts/mysql_install_db -user=mysqlcp ./support-files/mysql.server /etc/rc.d/init.d/mysqldchmod 755 /etc/rc.d/init.d/mysqldchkconfig -add mysqld chkconfig -level 3 mysqld on编译/etc/rc.d/init.d/mysqld vi/etc/rc.d/init.d/mysqld把basedir=编辑成basedir=/usr/local/mysql把datadir=编辑成datadir=/data/mysql/usr/local/mysql/bin/mysqld_safe&14960roothellomysql-5.0.56#Startingmysqlddaemonwithdatabasesfrom/usr/local/mysql/dataroothellomysql-5.0.56#netstat-lntp|grep3306tcp00:330:*LISTEN4983/mysqldbin/mysqladmin -u root password password_for_root其中引