Mysql 5.5 設定資料庫引數
可以透過SET命令來更改資料庫的引數
--全域性級別
mysql> show global variables like '%server%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| character_set_server | utf8 |
| collation_server | utf8_general_ci |
| server_id | 1 |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> set global character_set_server=gbk;
Query OK, 0 rows affected (0.10 sec)
mysql> show global variables like '%server%';
+----------------------+----------------+
| Variable_name | Value |
+----------------------+----------------+
| character_set_server | gbk |
| collation_server | gbk_chinese_ci |
| server_id | 1 |
+----------------------+----------------+
3 rows in set (0.01 sec)
也可以使用下面方式來修改
mysql> show global variables like 'character_set_server';
+----------------------+--------+
| Variable_name | Value |
+----------------------+--------+
| character_set_server | latin1 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> set @@global.character_set_server=gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'character_set_server';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| character_set_server | gbk |
+----------------------+-------+
1 row in set (0.01 sec)
--會話級別
mysql> set session character_set_server='utf8';
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like '%server%';
+----------------------+----------------+
| Variable_name | Value |
+----------------------+----------------+
| character_set_server | gbk |
| collation_server | gbk_chinese_ci |
| server_id | 1 |
+----------------------+----------------+
3 rows in set (0.00 sec)
--show variables查詢的是會話級別的引數
mysql> show variables like '%server%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| character_set_server | utf8 |
| collation_server | utf8_general_ci |
| server_id | 1 |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> show session variables like '%server%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| character_set_server | utf8 |
| collation_server | utf8_general_ci |
| server_id | 1 |
+----------------------+-----------------+
3 rows in set (0.00 sec)
即使是使用set global命令設定的引數,在資料庫重啟後,相關的引數也會失效;如果想讓引數永久生效,可以將引數寫在配置檔案裡面。
[root@localhost mysql]# vim /etc/my.cnf
--全域性級別
mysql> show global variables like '%server%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| character_set_server | utf8 |
| collation_server | utf8_general_ci |
| server_id | 1 |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> set global character_set_server=gbk;
Query OK, 0 rows affected (0.10 sec)
mysql> show global variables like '%server%';
+----------------------+----------------+
| Variable_name | Value |
+----------------------+----------------+
| character_set_server | gbk |
| collation_server | gbk_chinese_ci |
| server_id | 1 |
+----------------------+----------------+
3 rows in set (0.01 sec)
也可以使用下面方式來修改
mysql> show global variables like 'character_set_server';
+----------------------+--------+
| Variable_name | Value |
+----------------------+--------+
| character_set_server | latin1 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> set @@global.character_set_server=gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'character_set_server';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| character_set_server | gbk |
+----------------------+-------+
1 row in set (0.01 sec)
--會話級別
mysql> set session character_set_server='utf8';
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like '%server%';
+----------------------+----------------+
| Variable_name | Value |
+----------------------+----------------+
| character_set_server | gbk |
| collation_server | gbk_chinese_ci |
| server_id | 1 |
+----------------------+----------------+
3 rows in set (0.00 sec)
--show variables查詢的是會話級別的引數
mysql> show variables like '%server%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| character_set_server | utf8 |
| collation_server | utf8_general_ci |
| server_id | 1 |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> show session variables like '%server%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| character_set_server | utf8 |
| collation_server | utf8_general_ci |
| server_id | 1 |
+----------------------+-----------------+
3 rows in set (0.00 sec)
[root@localhost mysql]# vim /etc/my.cnf
# Character set
character_set_server = gbk
collation_server = gbk_bin
character_set_server = gbk
collation_server = gbk_bin
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2076945/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL資料庫引數MySql資料庫
- PostgreSQL DBA(1) - 資料庫引數設定#1SQL資料庫
- PostgreSQL DBA(2) - 資料庫引數設定#2SQL資料庫
- MySQL 5.7資料庫引數優化MySql資料庫優化
- MYSQL資料庫常用基本設定MySql資料庫
- MySQL 5.5 配置檔案設定MySql
- 設定DB_ULTRA_SAFE引數保障物理備用資料庫資料庫
- ORACLE RAC資料庫中的初始化引數的設定Oracle資料庫
- 【引數】DB_nK_CACHE_SIZE引數設定與資料庫預設塊大小之間的限制資料庫
- mysql的"雙1設定"-資料安全的關鍵引數(案例分享)MySql
- MySQL設定資料庫為只讀MySql資料庫
- 請問如何設定mysql資料庫?MySql資料庫
- Mysql 5.5 資料庫啟動關閉命令MySql資料庫
- MySQL 5.5 和 5.6 預設引數值的差異總結MySql
- Oracle 11G 資料庫重要的初始化引數設定Oracle資料庫
- 關於 oracle 設定引數時,scope型別為memory,重啟資料庫後引數失效Oracle型別資料庫
- Tomcat 5.5 配置 MySQL 資料庫連線池TomcatMySql資料庫
- 安裝oracle資料庫時,設定linux核心引數的意義Oracle資料庫Linux
- MySQL的配置檔案的引數設定MySql
- MySQL 5.5編譯安裝cmake引數說明MySql編譯
- MySql連線資料庫常用引數及程式碼示例MySql資料庫
- 調整資料庫引數資料庫
- Mysql資料庫優化系列(二)------AWK指令碼統計資料庫效能引數MySql資料庫優化指令碼
- Centos-Mysql建立資料庫-編碼設定CentOSMySql資料庫
- MySQL資料庫UTF8mb4設定MySql資料庫
- 設定如何遠端連線mysql資料庫MySql資料庫
- Mysql資料庫的遠端訪問設定MySql資料庫
- shmall引數設定不當引起資料庫啟動時報out of memory報錯資料庫
- MySQL 5.5客戶端字符集相關引數MySql客戶端
- MySQL 資料庫效能優化之快取引數優化MySql資料庫優化快取
- MySQL預設資料庫之mysql庫MySql資料庫
- Mysql資料庫的max_allowed_packet設定方法MySql資料庫
- Ubuntu安裝MySQL如何設定資料庫密碼UbuntuMySql資料庫密碼
- 檢視和設定MySQL資料庫字符集MySql資料庫
- mysql5.5資料庫cmake原始碼編譯安裝MySql資料庫原始碼編譯
- 顯示資料庫所有引數資料庫
- Oracle 資料庫引數調整Oracle資料庫
- mysql 5.5引數--innodb_read(write)_io_threadsMySqlthread