mysql新增使用者

使用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;