人妖在线一区,国产日韩欧美一区二区综合在线,国产啪精品视频网站免费,欧美内射深插日本少妇

新聞動態(tài)

MySQL修改默認(rèn)引擎和字符集詳情

發(fā)布日期:2022-02-06 16:44 | 文章來源:CSDN

一、數(shù)據(jù)庫引擎

1.1 查看數(shù)據(jù)庫引擎

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment| Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine              | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                 | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine             | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                 | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine     | NULL         | NULL | NULL       |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

可以看到默認(rèn)引擎是 InnoDB。

1.2 修改默認(rèn)數(shù)據(jù)庫引擎

1.打開配置文件

[root@VM_0_15_centos ~]# vim /etc/my.cnf

2.在最下面編輯如下內(nèi)容:

default-storage-engine=InnoDB

3.重啟服務(wù)

[root@VM_0_15_centos ~]# systemctl restart mysqld

二、數(shù)據(jù)庫字符集

2.1 查看字符集

查看MYSQL數(shù)據(jù)庫服務(wù)器和數(shù)據(jù)庫字符集

mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)

字符集 作用
character_set_client 用來設(shè)置客戶端使用的字符集。
character_set_connection 用來設(shè)置連接數(shù)據(jù)庫時的字符集
character_set_database 用來設(shè)置默認(rèn)創(chuàng)建數(shù)據(jù)庫的編碼格式
character_set_filesystem 文件系統(tǒng)的編碼格式,把操作系統(tǒng)上的文件名轉(zhuǎn)化成此字符集,默認(rèn)binary是不做任何轉(zhuǎn)換的
character_set_results 查詢結(jié)果字符集
character_set_server 服務(wù)器安裝時指定的默認(rèn)編碼格式
character_set_system 系統(tǒng)元數(shù)據(jù)(字段名等)字符集
character_sets_dir 字符集安裝的目錄

查看 MYSQL 所支持的字符集

show charset;

查看庫的字符集

show database status from 庫名 like  表名;

查看表的字符集

show table status from 庫名 like  表名;

查看表中所有列的字符集

show full columns from 表名;

2.2 修改字符集

1.打開配置文件

[root@VM_0_15_centos ~]# vim /etc/my.cnf

2.在最下面編輯如下內(nèi)容:

character-set-server=utf8
[client]
default-character-set=utf8

3.重啟服務(wù)并驗證

[root@VM_0_15_centos ~]# systemctl restart mysqld
[root@VM_0_15_centos ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.27 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| 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.00 sec)

到此這篇關(guān)于MySQL修改默認(rèn)引擎和字符集詳情的文章就介紹到這了,更多相關(guān)MySQL修改默認(rèn)引擎和字符集內(nèi)容請搜索本站以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持本站!

香港服務(wù)器租用

版權(quán)聲明:本站文章來源標(biāo)注為YINGSOO的內(nèi)容版權(quán)均為本站所有,歡迎引用、轉(zhuǎn)載,請保持原文完整并注明來源及原文鏈接。禁止復(fù)制或仿造本網(wǎng)站,禁止在非www.sddonglingsh.com所屬的服務(wù)器上建立鏡像,否則將依法追究法律責(zé)任。本站部分內(nèi)容來源于網(wǎng)友推薦、互聯(lián)網(wǎng)收集整理而來,僅供學(xué)習(xí)參考,不代表本站立場,如有內(nèi)容涉嫌侵權(quán),請聯(lián)系alex-e#qq.com處理。

實時開通

自選配置、實時開通

免備案

全球線路精選!

全天候客戶服務(wù)

7x24全年不間斷在線

專屬顧問服務(wù)

1對1客戶咨詢顧問

在線
客服

在線客服:7*24小時在線

客服
熱線

400-630-3752
7*24小時客服服務(wù)熱線

關(guān)注
微信

關(guān)注官方微信
頂部