linux mysql rpm 指定目录,linux mysql 安装源码包时什么参数指定数据库目录位置，rpm 包 安装后如何更改数据库目录位置...

1、安装cmake

tar zxf cmake-2.8.7.tar.gz

pushd cmake-2.8.7

./bootstrap && gmake && gmake install

popd

2、创建所需user及group及dir

groupadd mysql

useradd -g mysql mysql

mkdir -p /usr/local/mysql

mkdir -p /var/lib/mysql

chown -R mysql.mysql /usr/local/mysql /var/lib/mysql

3、安装mysql

tar zxf mysql-5.5.20.tar.gz

pushd mysql-5.5.20

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS:STRING=all \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/var/lib/mysql \

-DMYSQL_USER=mysql

make;make install

popd

4、制作配置文件

cat > my.cnf << EOF

[mysqld]

datadir=/var/lib/mysql

user=mysql

socket=/var/lib/mysql/mysql.sock

#Disablingsymbolic-links is recommended to prevent assorted security risks

symbolic-links=0

#skip-networking

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

EOF

5、初始化数据库

cd /usr/local/mysql

./scripts/mysql_install_db --datadir=/var/lib/mysql --user=mysql

6、定制启动脚本

cp mysql-5.5.20/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld

chkconfig mysqld on

/etc/init.d/mysqld start

7、修改管理员密码

./bin/mysqladmin -u root password 'password1'

8、rpm安装后更改mysql数据存放位置

vi /usr/local/mysql/my.cnf

修改

datadir=/var/lib/mysql