Basic MySQL commands in llinux (UBUNTU)

Connect to MySQL on the local machine: mysql-u user name-P User Password connect to remote MYSQL: mysql-H host address-u user name-P user password after entering msyql: Add a new user: grant select on Database Name. * To username @ login host address identified by "password" to view the current database: Show databases; use a database: Use Database Name to view all tables in the database: show tables; view the table content: Select * from table name; Create Database: Create Database database name; Create Table: Create Table Name (column 1 type, column 2 type) view the data structure of a table: Describe table name insert data: insert into table name values (); Delete data: delete from table name where condition; modify data: update content from table name where condition clear table: delete from table name; Delete table: Drop table name; delete database: drop database database name; Exit: Exit