使用root進入cmd line後
GRANT ALL ON dbname.* TO 'user'@localhost IDENTIFIED BY 'passwd' WITH GRANT OPTION; //localhost適用
GRANT ALL ON dbname.* TO 'user'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION; //開啟所有IP能連線適用
FLUSH PRIVILEGES;
GRANT ALL ON dbname.* TO 'user'@localhost IDENTIFIED BY 'passwd' WITH GRANT OPTION; //localhost適用
GRANT ALL ON dbname.* TO 'user'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION; //開啟所有IP能連線適用
FLUSH PRIVILEGES;