MySQL編碼Linux平台

Linux下安裝MySQL5.0.37需要以下面三個包:
MySQL-client-community-5.0.37-0.rhel3.i386.rpm
MySQL-server-community-5.0.37-0.rhel3.i386.rpm
perl-DBI-1.53-2.fc7.i386.rpm
(以下步驟需要root許可權)
1.驗證是否已經安裝過MySQL
rpm -qa|grep MySQL
如果發現有安裝過,並需要卸載,使用下面命令
rpm -e MySQL-client-community MySQL-server-community
2.安裝
執行:rpm -ivh MySQL-client-community-5.0.37-0.rhel3.i386.rpm MySQL-server-community-5.0.37-0.rhel3.i386.rpm
如果控制台提示:
error: Failed dependencies:
perl(DBI) is needed by MySQL-client-community-5.0.37-0.rhel3.i386
perl(DBI) is needed by MySQL-server-community-5.0.37-0.rhel3.i386
代表當前作業系統缺少DBI模組,請先安裝DBI模組.
rpm -ivh perl-DBI-1.53-2.fc7.i386.rpm
提示下面文字代表正確安裝:
Preparing... ########################################### [100%]
1:perl-DBI ########################################### [100%]
重新執行MySQL的安裝命令
提示下面文字代表正確安裝:
Preparing... ########################################### [100%]
1:MySQL-server-community ########################################### [ 50%]
2:MySQL-client-community ########################################### [100%]
3.初始化安裝
/usr/bin/mysql_install_db
4.啟動mysql
/etc/init.d/mysql start
(停止有兩種方法:[mysqladmin -uroot -p shutdown] [/etc/init.d/mysql stop])
5.驗證安裝成功
netstat -nat|grep 3306
如果能看到下面一行說明正常安裝:
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
6.修改mysql的root使用者密碼
mysqladmin -u root password '123456'
7.登陸mysql用戶端
mysql -uroot -p
輸入:123456
8.建立資料庫
mysql> create database gbkdb character set gbk;
Query OK, 1 row affected (0.01 sec)
9.為資料庫gbkdb建立使用者(使用者:user 密碼:123)
mysql> grant select,insert,update,delete,create on gbkdb.* to user@"%" identified by "123";
Query OK, 0 rows affected (0.01 sec)10.修改配置
cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
vi /etc/my.cnf
在[client]下面增加一行:
[client]
default-character-set = gbk
在[mysqld]下面增加三行:
[mysqld]
default-character-set = gbk
default-collation = gbk_chinese_ci
init_connect = 'SET NAMES gbk'
在[mysql]下面增加一行:
[mysql]
default-character-set = gbk
11.重啟MySQL
/etc/init.d/mysql restart
12.重登陸mysql控制台確認配置變化
mysql -uroot -p
輸入:123456
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/share/mysql/charsets/ |
+--------------------------+----------------------------+
13.在遠程使用控制台登陸,確認使用者可以使用
mysql -h10.10.1.156 -uuser -p
輸入:123
mysql> use gbkdb;
Database changed

1 2 下一頁