设置远程用户root密码
mysql> update user set password=password("12345") where user='root' and host='%';
查询所有用户
select user,host,password from mysql.users;
远程登录
mysql -h $ip -u $user -p
显示数据库
show databases;
使用数据库
use $dbname;
显示当前数据库所有表
show tables;
显示表结构
describe $tablename;
授权
grant ...(all priveleges|select,insert,update,delete,create,drop)
on *.*($dbname.*|$dbname.$tablename)
to '$name'@'$host'
identified by '$password';
解除授权
revoke ...
on *.*
from '$name'@'$host';
use mysql;
delete from user where user='$username' and host='%';
flush privileges;
创建表
create table student_ex(name varchar(20),age int);
修改表名字
alter table student_ex rename person;
修改表结构
alter table person modify name varchar(30) not null;
alter table person add address varchar(100);
alter table person drop column address;
增加约束
alter table person add index(name),add primary key(name);
alter table person add id int unsigned not null auto_increment,add index(
id);
create index index_person1 on person(name(10));
帮助
help;
help contents;
help show;