Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save kindofblue/6fd6d5b7bc845fa7da229d618c14db2b to your computer and use it in GitHub Desktop.
Save kindofblue/6fd6d5b7bc845fa7da229d618c14db2b to your computer and use it in GitHub Desktop.
mysql tip
1. use \G at the end of query to show multiple lines.
2. mysql -h<host> -P<port> -u<user> -p<password> -e "sql statement"
3. when create user, '%' does not match 'localhost'.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment