VPS鍒涘缓MySQL鏁版嵁搴撴楠ゆ寚鍗楋細閰嶇疆涓庡瓧绗﹂泦璁剧疆璇﹁В

涓€銆丮ySQL鐜瀹夎涓庡熀纭€閰嶇疆

鍦╒PS鐜涓畨瑁匨ySQL寤鸿閫氳繃瀹樻柟浠撳簱鑾峰彇鏈€鏂扮ǔ瀹氱増鏈€傛墽琛?code>sudo apt-get install mysql-server鍛戒护瀹屾垚鍩虹瀹夎鍚庯紝闇€杩愯mysql_secure_installation杩涜瀹夊叏鍒濆鍖栭厤缃紝鍖呮嫭璁剧疆root瀵嗙爜銆佺Щ闄ゅ尶鍚嶇敤鎴风瓑瀹夊叏鍔犲浐鎿嶄綔銆?/p>

浜屻€佹湇鍔″櫒鍙傛暟閰嶇疆鏂囦欢璁剧疆

MySQL鐨勫叏灞€閰嶇疆閫氳繃my.cnf(Linux)鎴?code>my.ini(Windows)鏂囦欢瀹炵幇銆傚缓璁紭鍏堜慨鏀逛互涓嬫牳蹇冨弬鏁帮細

[mysqld]娈垫坊鍔?code>character-set-server=utf8mb4缁熶竴榛樿瀛楃闆?/li>
璁剧疆collation-server=utf8mb4_unicode_ci鎸囧畾鏍″瑙勫垯
璋冩暣innodb_buffer_pool_size浼樺寲InnoDB鎬ц兘

涓夈€佹暟鎹簱鍒涘缓涓庡瓧绗﹂泦鎸囧畾

閫氳繃MySQL瀹㈡埛绔墽琛屾暟鎹簱鍒涘缓鏃讹紝鎺ㄨ崘鏄惧紡鎸囧畾瀛楃闆嗭細

鐧诲綍鏁版嵁搴擄細mysql -u root -p
鍒涘缓鏁版嵁搴擄細CREATE DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
楠岃瘉璁剧疆锛?code>SHOW CREATE DATABASE dbname;

鍥涖€佹暟鎹〃瀛楃闆嗗簲鐢ㄥ疄璺?/h2>

鍒涘缓鏁版嵁琛ㄦ椂寤鸿閲囩敤缁ф壙寮忓瓧绗﹂泦璁剧疆锛?/p>

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) CHARACTER SET utf8mb4
) DEFAULT CHARSET=utf8mb4;

閫氳繃ALTER TABLE璇彞鍙鐜版湁琛ㄨ繘琛屽瓧绗﹂泦鍙樻洿锛屼絾闇€娉ㄦ剰宸叉湁鏁版嵁鐨勮浆鎹㈤闄┿€?/p>

浜斻€佸瓧绗﹂泦楠岃瘉涓庣淮鎶ゅ缓璁?/h2>

寤鸿瀹氭湡鎵ц浠ヤ笅缁存姢鍛戒护锛?/p>

瀛楃闆嗛獙璇佹寚浠よ〃
妫€鏌ラ」鍛戒护

鍏ㄥ眬璁剧疆 `SHOW VARIABLES LIKE 'char%';`

鏁版嵁搴撹缃?/td>
`SHOW CREATE DATABASE dbname;`

琛ㄦ牸璁剧疆 `SHOW CREATE TABLE tablename;`

鍙戠幇瀛楃闆嗕笉鍖归厤鏃跺簲閫氳繃`ALTER`璇彞鍙婃椂淇锛岄伩鍏嶆暟鎹瓨鍌ㄥ紓甯搞€?/p>

缁撹锛?/strong>閫氳繃閰嶇疆鏂囦欢棰勫畾涔夈€佹暟鎹簱绾х户鎵裤€佽〃绾ц鐩栫殑涓夊眰瀛楃闆嗙鐞嗕綋绯伙紝鍙湁鏁堢‘淇濆璇█鏁版嵁鐨勫瓨鍌ㄤ竴鑷存€с€傚缓璁敓浜х幆澧冪粺涓€閲囩敤`utf8mb4`瀛楃闆嗕互鏀寔emoji绛夋墿灞曞瓧绗︺€?/p>

瀛楃闆嗛獙璇佹寚浠よ〃
妫€鏌ラ」	鍛戒护
鍏ㄥ眬璁剧疆	`SHOW VARIABLES LIKE 'char%';`
鏁版嵁搴撹缃?/td>	`SHOW CREATE DATABASE dbname;`
琛ㄦ牸璁剧疆	`SHOW CREATE TABLE tablename;`