安装mysql

目的:  为mysql在指定目录安装独立的数据库。
1. 安装mysql客户端
rmp -Uvh MySQL-client-5.5.8-1.linux2.6.x86_64.rpm
2. 在/home/mysql下安装mysql数据库服务器
groupadd mysql
useradd -r -g mysql mysql
cd /home/mysql
tar xvzf mysql-5.5.8-linux2.6-x86_64.tar.gz
ln -s mysql-5.5.8-linux2.6-x86_64.tar.gz latest
cd latest
chown -R mysql .
chgrp -R mysql .
chown -R root .
chown -R mysql data
cp support-files/my-huge.cnf /etc/my.cnf

gedit  /etc/my.cnf
[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
character-set-server=utf8
default-storage-engine=INNODB  

scripts/mysql_install_db --user=mysql --basedir=/home/mysql/latest --datadir=/home/mysql/latest/data
bin/mysqld_safe --user=mysql &
cp support-files/mysql.server /etc/init.d/mysqld
gedit /etc/init.d/mysqld
basedir=/home/mysql/latest 
datadir=/home/mysql/latest/data
chkconfig --level 2345 mysqld on
service mysqld start

3.  清空repository数据，重新设置
mysql
drop database repository;

4.  清空数据，重新设置
service mysqld stop
cd /home/mysql/latest/data
rm -f *
rm -f ./mysql
rm -f ./p*/*
scripts/mysql_install_db --user=mysql --basedir=/home/mysql/latest --datadir=/home/mysql/latest/data
mysqladmin -u root password 'njw****'
service mysqld start

5. 建立repository数据库
mysql --user=root --password='njw****'
create database repository;
grant all privileges ON *.* TO ramadda@"localhost" identified by 'njw****';
grant super on *.* to rmadda@"localhost" identified by 'njw****';
flush privileges;
quit;

mysql --user=ramadda --password='njw****'