Skip to content

Instantly share code, notes, and snippets.

@mungomash
Created January 7, 2012 16:42
Show Gist options
  • Save mungomash/1575248 to your computer and use it in GitHub Desktop.
Save mungomash/1575248 to your computer and use it in GitHub Desktop.
MySQL monitor cheat sheet
-- create database
create database wp_blog;
-- create user
create user uwp_blog@localhost identified by 'pass123';
-- grant access
grant all privileges on wp_blog.* to uwp_blog@localhost;
-- list databases user has access to
show databases;
-- list tables in a database
show tables;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment