1. 在mysql5.0版中,運行mysql命令時,出現錯誤提示,提示內容為:
mysql: Character set 'utf-8' is not a compiled character set and is not specified in the 'C:"mysql""share"charsets"Index.xml' file
解決方法為打開mysql安裝路徑下的my.ini,把:
default-character-set=utf-8修改為default-character-set=utf8,重啟mysql服務
2.使用mysql可以遠程訪問的方法
打開dos窗口,進入mysql的安裝目錄下的bin目錄。
輸入:mysql -u root -p
輸入密碼:******
執行命令:
use mysql;
GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES ;
mysql: Character set 'utf-8' is not a compiled character set and is not specified in the 'C:"mysql""share"charsets"Index.xml' file
解決方法為打開mysql安裝路徑下的my.ini,把:
default-character-set=utf-8修改為default-character-set=utf8,重啟mysql服務
2.使用mysql可以遠程訪問的方法
打開dos窗口,進入mysql的安裝目錄下的bin目錄。
輸入:mysql -u root -p
輸入密碼:******
執行命令:
use mysql;
GRANT ALL ON *.* TO root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES ;