linux下mysql源码安装

查看已经安装的mysql：rpm -qa|grep mysql
删除旧版本： rpm -e --nodeps mysql-4.1.20-2.RHEL4.1
rpm -e --nodeps mysql-server-4.1.20-2.RHEL4.1

一、 使用源码安装
# cd /usr/local
# rz mysql-5.1.48.tar
# groupadd mysql
# useradd -g mysql mysql
tar -xvf mysql-5.1.48.tar
# cd /usr/local/mysql-5.1.48/
# ./configure --prefix=/usr/local/mysql --with-plugins=innobase
# make && make install
# chown -R mysql:mysql /usr/local/mysql/
#
cp /usr/local/mysql-5.1.48/support-files/my-medium.cnf /etc/my.cnf
创建数据目录
mkdir -p /data/mysqldata/

数据库装好后修改数据存储目录
vi /etc/my.cnf
[mysqld]
default-character-set=utf8
lower_case_table_names=1
skip-external-locking
datadir = /data/mysqldata
default-storage-engine=INNODB

这里默认basedir是/usr/local/mysql所以不用配置

拷贝之前的数据文件
cp /usr/local/mysql/var/* /data/mysqldata -R
chown -R mysql.mysql /data/mysqldata/

# cp /usr/local/mysql-5.1.48/support-files/mysql.server /etc/init.d/mysqld

# /usr/local/mysql/bin/mysql_install_db --user=mysql
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
# chmod 755 /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig mysqld on
# service mysqld start

/etc/profile中指定环境变量
export MYSQL_HOME=/usr/local/mysql
export PATH=$JAVA_HOME/bin:$MYSQL_HOME/bin:$PATH

source /etc/profile

创建用户
/usr/local/mysql/bin/mysqladmin -u root -h localhost password 'root'