mysql.md

Basic Concepts

user management

• create user

  CREATE USER 'username'@'hostname' IDENTIFIED BY 'password';

• privileges management

  GRANT [privilege1,previlige2,...] ON [database_name].* TO 'user_name'@'host_name';

  privilege types:
  • select
  • update
  • insert
  • delete

database management

• create a database

  create database [database_name];

• export database to a file

  mysqldump [database_name] > [file_name]

• import data from dump file

  mysql [database_name] < [dumpfile.sql];

table management

Basic Operations

1. login at local machine use CLI.

   mysql -u [username] -p

2. list all databases that current login user privileged.(after login mysql)

   show databases;

3. enter one database.

   use [database_name];

4. list all tables in one database that was entered.

   show tables;

5. list data row in one table;

   select [*[column1[,column2]] from [table_name];
   

local run

To connect run:

    mysql -uroot -p