下載軟件
- NCRE官網(wǎng)的二級MySQL考試應(yīng)用軟件下載 ： 點(diǎn)擊下載
- WinRAR解壓軟件 ：點(diǎn)擊下載
- 微軟常用運(yùn)行庫合集： 點(diǎn)擊下載：來源https://www.mefcl.com/yxk-dreamcast/249
安裝步驟
1. Win11首先安裝微軟常用運(yùn)行庫合集
2. 安裝WinRAR解壓軟件
3. 解壓安裝二級MySQL應(yīng)用軟件WampServer
wampserver2.2e-php5.4.3-httpd2.2.22-mysql5.5.24-32b
安裝過程要選擇默認(rèn)瀏覽器，選擇Win11自帶Microsoft Edge瀏覽器
選擇瀏覽器路徑：C:\Program Files (x86)\Microsoft\Edge\Application
選擇瀏覽器文件：msedge
設(shè)置WampServer服務(wù)器phpMyAdmin
1. 設(shè)置Wampserver中文界面
右擊任務(wù)欄wampserver圖標(biāo)，Language選擇chinese，設(shè)置中文
2. 編輯Apache配置文件httpd.conf
點(diǎn)擊任務(wù)欄wampserver圖標(biāo)，選擇Apache，點(diǎn)擊httpd.conf，
在配置文件httpd.conf 中查找127
把文件中127上面一行 Deny from all 改成 Alllow from all
保存關(guān)閉。
3. 編輯alias文件
點(diǎn)擊任務(wù)欄wampserver圖標(biāo)，選擇Apache，點(diǎn)擊Alias目錄，選擇http://localhost/phpmyadmin，
點(diǎn)擊Edit alias，編輯alias文件
同樣把文件中127上面一行 Deny from all 改成 Alllow from all
保存關(guān)閉。
4. 啟動phpMyAdmin
點(diǎn)擊任務(wù)欄wampserver圖標(biāo)重新啟動所有服務(wù)，點(diǎn)擊phpMyAdmin，
瀏覽器就能打開phpMyAdmin。
phpMyAdmin “服務(wù)器連接校對” 默認(rèn)字符排序規(guī)則是：utf8_general_ci，
更改排序規(guī)則為：utf8mb4_unicode_ci
配置MySQL環(huán)境變量，運(yùn)行MySQL數(shù)據(jù)庫
1. 右擊開始菜單，選擇系統(tǒng)
2. 點(diǎn)擊“高級系統(tǒng)設(shè)置”
3. 點(diǎn)擊“環(huán)境變量”，然后點(diǎn)擊系統(tǒng)變量的Path，
點(diǎn)擊新建，添加mysql路徑：C:\wamp\bin\mysql\mysql5.5.24\bin
確定關(guān)閉。
4. 啟動MySQL
任務(wù)欄輸入CMD，點(diǎn)擊運(yùn)行“命令提示符”
輸入命令：mysql -uroot -p
提示輸入密碼，因?yàn)槟J(rèn)沒有密碼，所以直接按回車鍵就能啟動mysql
5. 設(shè)置MySQL字符集
查看當(dāng)前版本命令：select version();
mysql> select version();
+------------+
| version() |
+------------+
| 5.5.24-log |
+------------+
1 row in set (0.00 sec)
查看當(dāng)前字符集命令：show variables like “%char%”;
mysql> show variables like "%char%";
+--------------------------+-----------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | c:\wamp\bin\mysql\mysql5.5.24\share\charsets\ |
+--------------------------+-----------------------------------------------+
8 rows in set (0.02 sec)
查看字符排序規(guī)則命令：show variables like “%colla%”;
mysql> show variables like "%colla%";
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | gbk_chinese_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
修改mysql配置文件my.ini，設(shè)置創(chuàng)建數(shù)據(jù)庫默認(rèn)的字符集為utf8mb4
打開my.ini文件，拉動到文件尾部
看到
[mysqld]
port=3306
在下面添加2句命令，創(chuàng)建數(shù)據(jù)庫字符集和排序規(guī)則的設(shè)置：
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect=‘SET NAMES utf8mb4’
保存配置文件退出。
只要加這3句命令，其他都不要設(shè)置！否則二級MySQL數(shù)據(jù)庫的中文會顯示亂碼！
6. 用MySQL控制臺啟動MySQL，查看字符集
點(diǎn)擊任務(wù)欄wampserver圖標(biāo)重新啟動所有服務(wù)，
再點(diǎn)擊MySQL——MySQL控制臺，按回車進(jìn)入mysql
文章來源：http://www.zghlxwxcb.cn/news/detail-830340.html
查詢所有數(shù)據(jù)庫命令： show databases;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
查詢創(chuàng)建數(shù)據(jù)庫默認(rèn)字符集和排序規(guī)則已經(jīng)是utf8mb4文章來源地址http://www.zghlxwxcb.cn/news/detail-830340.html
mysql> show variables like "%char%";
+--------------------------+-----------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | c:\wamp\bin\mysql\mysql5.5.24\share\charsets\ |
+--------------------------+-----------------------------------------------+
8 rows in set (0.00 sec)
mysql> show variables like "%colla%";
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | gbk_chinese_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+----------------------+--------------------+
3 rows in set (0.00 sec)
創(chuàng)建數(shù)據(jù)庫命令： create database db_school;
查看創(chuàng)建的數(shù)據(jù)庫字符集命令：show create database db_school;
mysql> create database db_school;
Query OK, 1 row affected (0.02 sec)
mysql> show create database db_school;
+-----------+--------------------------------------------------------------------------------------------------+
| Database | Create Database |
+-----------+--------------------------------------------------------------------------------------------------+
| db_school | CREATE DATABASE `db_school` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ |
+-----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
到了這里，關(guān)于Win11系統(tǒng)設(shè)置計(jì)算機(jī)二級MySQL環(huán)境變量，設(shè)置創(chuàng)建數(shù)據(jù)庫默認(rèn)的字符集為utf8mb4，設(shè)置WampServer服務(wù)器phpMyAdmin程序。的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
