Basic Concepts

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