MySQL

From Guides

Contents 1 Installation 2 Basic Commands 2.1 Databases 2.2 Users 2.3 Tables 3 Documentation

Installation

Basic Commands

Databases

• Create:

  create database <db_name>

• Read:

  show databases

Users

• Create:

  CREATE USER <username> [IDENTIFIED BY [PASSWORD] '<password>']
      [, user [IDENTIFIED BY [PASSWORD] 'password']]

• Read:

  SELECT * from mysql.user;
  -- To limit the width assign specific columns.
  desc mysql.user;
  

Tables

Documentation

Official MySQL Reference Manual