Skip to content

Instantly share code, notes, and snippets.

@omps

omps/gist:9f9fb5ed0f70f5bccfc30c496d87ffef

Created January 4, 2017 16:49
Show Gist options
  • Save omps/9f9fb5ed0f70f5bccfc30c496d87ffef to your computer and use it in GitHub Desktop.
Save omps/9f9fb5ed0f70f5bccfc30c496d87ffef to your computer and use it in GitHub Desktop.
Download ZIP
mysql common pitfalls.
Raw
gistfile1.txt
# show all users in the db.
SELECT User FROM mysql.user;
#create database
create database mysql_test;
# create new mysql user
GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment