檢視和設定MySQL資料庫字符集
檢視和設定MySQL資料庫字符集
Liunx下修改MySQL字符集:
1.查詢MySQL的cnf檔案的位置
find / -iname '*.cnf' -print
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/texmf/web2c/texmf.cnf
/usr/share/texmf/web2c/mktex.cnf
/usr/share/texmf/web2c/fmtutil.cnf
/usr/share/texmf/tex/xmltex/xmltexfmtutil.cnf
/usr/share/texmf/tex/jadetex/jadefmtutil.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-large.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-small.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.1.22/my-huge.cnf
2. 複製 small.cnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4G.cnf其中的一個到/etc下,命名為my.cnf
cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
3. 修改my.cnf
vi /etc/my.cnf
在[client]下新增
default-character-set=utf8
在[mysqld]下新增
default-character-set=utf8
4.重新啟動MySQL
[root@bogon ~]# /etc/rc.d/init.d/mysql restart
Shutting down MySQL [ 確定 ]
Starting MySQL. [ 確定 ]
[root@bogon ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.1.22-rc-community-log MySQL Community Edition (GPL)
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
5.檢視字符集設定
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.02 sec)
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.02 sec)
mysql>
其他的一些設定方法:
修改資料庫的字符集
mysql>use mydb
mysql>alter database mydb character set utf-8;
建立資料庫指定資料庫的字符集
mysql>create database mydb character set utf-8;
透過配置檔案修改:
修改/var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-collation=latin1_swedish_ci
為
default-character-set=utf8
default-collation=utf8_general_ci
重起MySQL:
[root@bogon ~]# /etc/rc.d/init.d/mysql restart
透過MySQL命令列修改:
mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)
檢視:
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.03 sec)
mysql> show variables like 'collation_%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.04 sec)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14663377/viewspace-1034852/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql字符集檢視與設定MySql
- MySQL資料庫檢視:檢視定義、建立檢視、修改檢視MySql資料庫
- 檢視oracle資料庫字符集Oracle資料庫
- R1-010 MySQL檢視資料庫字符集MySql資料庫
- linux下設定mysql資料庫字符集utf8LinuxMySql資料庫
- MySQL檢視當前資料庫庫MySql資料庫
- MySQL 檢視與修改預設字符集MySql
- Oracle字符集的檢視查詢和Oracle字符集的設定修改Oracle
- MySQL檢視和修改字符集的方法MySql
- 檢視MySQL資料庫的命令MySql資料庫
- MySQL命令檢視資料庫和表容量大小MySql資料庫
- 檢視引數(parameter)的字典與資料庫字符集資料庫
- 設定Mysql字符集MySql
- mysql字符集設定MySql
- 用SQL命令檢視Mysql資料庫大小MySql資料庫
- MySQL 5.5建立和檢視資料庫計劃任務(event)MySql資料庫
- MYSQL資料庫常用基本設定MySql資料庫
- android 檢視資料庫和shaedpreference資料框架Android資料庫框架
- 檢視MySQL資料庫大小的方法總結MySql資料庫
- MYSQL-檢視資料庫或表的大小MySql資料庫
- 檢視mysql資料庫空間使用情況MySql資料庫
- 三種檢視MySQL資料庫版本的方法MySql資料庫
- Windows使用Apche並檢視MySQL資料庫(轉)WindowsMySql資料庫
- oracle資料庫字符集設定的查詢語法Oracle資料庫
- MySQL設定資料庫為只讀MySql資料庫
- Mysql 5.5 設定資料庫引數MySql資料庫
- 請問如何設定mysql資料庫?MySql資料庫
- linux下mysql的預設字符集修改和預設資料庫引擎的修改LinuxMySql資料庫
- 檢視和修改Oracle字符集Oracle
- MySQL字符集基本概念和詳細設定MySql
- MySQL資料庫健康檢查--MySQL巡檢MySql資料庫
- MySQL檢視資料庫效能常用命令和實戰教學MySql資料庫
- 如何在Windows下利用Apche檢視MySQL資料庫?WindowsMySql資料庫
- Redis 密碼設定和檢視Redis密碼
- 使用物化檢視實現在不同字符集的資料庫之間的資料同步資料庫
- MySQL資料庫之mysql5.7基礎 檢視一個資料庫中的所有表MySql資料庫
- Oracle字符集的檢視和修改Oracle
- Oracle 字符集的檢視和修改Oracle