执行以下步骤进行MYSQL5.0的安装:
将mysql-standard-5.0.26-linux-i686-glibc23.tar.gz拷贝到/usr/local目录下
1. 解压并创建mysql链接
shell>cd /usr/local
shell>tar –xvf mysql-standard-5.0.26-linux-i686-glibc23.tar.gz
shell>ln –s mysql-standard-5.0.26-linux-i686 mysql
2. 为‘mysqld’增添一个登陆用户和组
shell> cd mysql
shell> groupadd mysql
shell> useradd -g mysql mysql
3. 执行安装脚本,
shell> scrīpts/mysql_install_db --user=mysql
4. 改变属权限
shell>chown -R root . (注意小数点)
shell>chown -R mysql data
shell>chgrp -R mysql . (注意小数点)
5.运行你的MySQL:
Shell>cd /usr/local/mysql/bin
shell>./mysqld_safe --user=mysql &
6、修改字符集
shell>cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
shell>vi /etc/my.cnf
在[client]下添加
default-character-set=gbk
在[mysqld]下添加
default-character-set=gbk
进入mysql执行相关命令查看字符集是否设置好:
mysql> show variables like 'collation_%';
+----------------------+----------------+
| Variable_name | Value |
+----------------------+----------------+
| collation_connection | gbk_chinese_ci |
| collation_database | gbk_chinese_ci |
| collation_server | gbk_chinese_ci |
+----------------------+----------------+
mysql> show variables like 'character_set_%';
+--------------------------+-------------------------------------------------------------------+
| Variable_name | Value
+--------------------------+-------------------------------------------------------------------+
| character_set_client | gbk
| character_set_connection | gbk
| character_set_database | gbk
| character_set_filesystem | binary
| character_set_results | gbk
| character_set_server | gbk
| character_set_system | utf8
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+-------------------------------------------------------------------+
6.服务启动后授权
Shell>cd /usr/local/mysql/bin
shell>./mysql
mysql>grant all on *.* to root@'%' identified by '' with grant option;