davidgg/mysql-helpful-commands.md

## mysql-helpful-commands.md

      
    Raw
  

              mysql-helpful-commands.md
            
          
    MySql Helpful Commands

Connect

mysql -u [username] -p;
Show all databases

show databases;
Use database

use [database];
Show all tables

show tables;
Show table structure

describe [table];
List users

SELECT User,Host FROM mysql.user;
source: https://gist.github.com/hofmannsven/9164408