修改mysql數(shù)據(jù)庫排序規(guī)則的方法
1.首先,在命令行中啟動MySQL服務(wù);
service mysql start
2.MySQL服務(wù)啟動后,在命令行中輸入mysql的用戶名和密碼登錄到MySQL;
mysql -u root -p
3.登錄到MySQL后,選擇使用一個數(shù)據(jù)庫;
use mysql;
4.進入到數(shù)據(jù)庫后,在數(shù)據(jù)庫中執(zhí)行以下命令查看數(shù)據(jù)庫的排序規(guī)則;
show variables like 'collation%';
5.最后,查看到數(shù)據(jù)庫排序規(guī)則后,使用以下命令即可對數(shù)據(jù)庫排序規(guī)則進行修改;
SELECT DISTINCT concat('ALTER DATABASE `', TABLE_SCHEMA, '` CHARACTER SET utf8 COLLATE utf8_unicode_ci;')
from information_schema.tables
where TABLE_SCHEMA like 'database_name';