Skip to content

Instantly share code, notes, and snippets.

@bunnywong

bunnywong/gist:9b9d85039e00810455f5

Last active August 29, 2015 14:26
Show Gist options
  • Save bunnywong/9b9d85039e00810455f5 to your computer and use it in GitHub Desktop.
Save bunnywong/9b9d85039e00810455f5 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Color & Permission
Raw
gistfile1.txt
Installed color MySQL
https://github.com/nitso/colour-mysql-console
Access from host
> ip add
mysql> mysql -u root;
mysql> grant all on prefix.* to [email protected];
mysql> flush privileges;
Check status
mysql> mysql -u root;
mysql> use mysql;
mysql> select user, host from user;
Ref:
https://dev.mysql.com/doc/refman/5.1/en/grant.html
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment