slack ware下安装配置mysql

yancncen

slack ware下安装mysql.

最近在slack ware下安装配置了mysql,把过程记录下来.

文件:mysql-standard-5.0.20.tar.gz
(1)解压到/usr/local/mysql下
gunzip mysql-standard-5.0.20.tar.gz
tar -vxf mysql-standard-5.0.20.tar
cp -r mysql-standard-5.0.20 mysql
rm -r mysql-standard-5.0.20
(2)安装
./configure --prefix=/usr/local/mysql --with-charset=gbk --with-extra-charsets="gbk gb2312"
(3)安装后配置
./scripts/mysql_install_db
若出错,把./share/fill_help_tables.sql复制到./support-files/目录下
(4)把配置文件放到/etc/my.cnf
cp ./support-files/my-small.cnf /etc/my.cnf
修改/ect/my.cnf
在[mysqld]下加入
user  = root    //以root启动mysql
default-character-set = gb2312 //修改默认字符集为gb2312

(5)为root添加密码,并用root登陆到mysql
./bin/mysqladmin -u root password 'new-password'
mysql -hlocalhost -uroot -pnew-password
(6)新建远程登陆的用户
GRANT ALL PRIVILEGES ON *.* TO "user"@"%" IDENTIFIED BY "password" WITH GRANT OPTION

(6)启动mysql
/usr/local/mysql/support-files/mysql.server start


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/19815/showart_124274.html