mysql5.58编译安装手记
mysql5.58的编译安装cmake-2.8.3.tar.gz
mysql-5.5.8.tar.gz
一，cmake-2.8.3的安装：
tar -zxf cmake-2.8.3.tar.gz
cd cmake-2.8.3
# ./configure
#make;make install
二，mysql5.58的安装：
1，建立mysql用户和组
# groupadd -g 2001 mysql
# useradd -M -s /sbin/nologin -u 2001 -g 2001 mysql
2，编译mysql的安装
# tar -zxf mysql-5.5.8.tar.gz
# cd mysql-5.5.8
# cmake . \
> -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5 \
> -DINSTALL_DATADIR=/usr/local/mysql5/data \
> -DDEFAULT_CHARSET=utf8 \
> -DEXTRA_CHARSETS=all \
> -DMYSQL_USER=mysql
#make;make instal
# mv /etc/my.cnf /etc/my.cnf.bak
# cp /usr/local/mysql5/support-files/my-medium.cnf /etc/my.cnf
# vi /etc/my.cnf
（在mysqld下方加入两条参数）
basedir=/usr/local/mysql5
datadir=/usr/local/mysql5/data
# cd /usr/local/mysql5/
# scripts/mysql_install_db \
--user=mysql\
--basedir=/usr/local/mysql5\
--datadir=/usr/local/mysql5/data
# chown -R mysql:mysql /usr/local/mysql5/data/
# chgrp -R mysql /usr/local/mysql5/
# bin/mysqld_safe --user=mysql &
# bin/mysqladmin -u root password 123456
# bin/mysql -uroot -p123456
mysql> show databases;
3,把mysql加入到系统服务中
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --list | grep mysql
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
# service mysqld status
MySQL running (20047)
# service mysqld restart
Shutting down MySQL.
Starting MySQL..
# /etc/rc.d/init.d/mysqld restart
Shutting down MySQL.
Starting MySQL..
页:
[1]