centos下mysql手工安装

下载二进制安装包(mysql-5.5.15-linux2.6-i686.tar.gz)
解压到相关目录(/software/mysql-5.5.15-linux2.6-i686)
建立软链接
ln -s mysql-5.5.15-linux2.6-i686 mysql
cd mysql
cd support-files
cp my-medium.cnf ../etc/my.cnf


修改所有socket          = /software/mysql/tmp/mysql.sock
[mysqld]
添加datadir         = /data0/mysql/data
添加user=hadoop


初始化数据库
./scripts/mysql_install_db --defaults-file=/software/mysql/etc/my.cnf 


启动数据库
 ./bin/mysqld_safe  --defaults-file=/software/mysql/etc/my.cnf &


登陆
./bin/mysql --defaults-file=//software/mysql/etc/my.cnf -uroot


开放远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
TH GRANT OPTION;
EXIT;


关闭防火墙,此处开始时忘记关闭,远程访问不了
/etc/init.d/iptables stop


建立用户
GRANT ALL ON guosou_sls.* TO 'gssls'@'%' IDENTIFIED BY 'gssls123';