建帳號
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:
矇著眼建立帳號
http://blog.xuite.net/tolarku/blog/58951359-%5BMySQL%5D+%E7%9F%87%E8%91%97%E7%9C%BC%E5%BB%BA%E7%AB%8B%E5%B8%B3%E8%99%9F
MySQL 新增使用者與權限設定 (筆記)
http://blog.toright.com/posts/1214/mysql-%E6%96%B0%E5%A2%9E%E4%BD%BF%E7%94%A8%E8%80%85%E8%88%87%E6%AC%8A%E9%99%90%E8%A8%AD%E5%AE%9A-%E7%AD%86%E8%A8%98
頁:
[1]