登录 mysql -u username -p
新建用户 create user username@host idenfitied by 'password'
显示所有数据库 SHOW DATABASES
显示所有用户 SELECT USER,HOST FROM mysql.user
显示用户权限 SHOW GRANTS FOR user@serverhost
进入数据库 use databasename
新建表单 create table tablename (id int auto_increment primary key, b char(10), c char(10))
删除表单 drop table tablename
显示表单 show tables
显示表单表头 show columns in tablename
插入数据 insert into tableaname (b,c) values ("tt","kk")