一、創建用戶

CREATE USER '用戶名'@'%' IDENTIFIED BY '密碼';

flush privileges;

二、更新用戶密碼

update mysql.user set authentication_string=password("密碼") where user='root';

flush privileges;

三、允許root遠程登錄
update user set host = '%' where user = 'root';

flush privileges;

四、授權，可重新設置密碼

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密碼' WITH GRANT OPTION;

flush privileges;

五、創建數據庫，并指定字符編碼

create database 庫 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;