建帳號

JDP

mysql -u root -p 登入進去
mysql> use mysql;
mysql> insert into user (host,user,password) values ('%','account',password('password'));
mysql> GRANT ALL ON *.* TO 'account'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

Reference:
[MySQL] 矇著眼建立帳號
http://blog.xuite.net/tolarku/bl ... B%E5%B8%B3%E8%99%9F
MySQL 新增使用者與權限設定 (筆記)
http://blog.toright.com/posts/12 ... -%E7%AD%86%E8%A8%98