MySQL授权的用户命令实例分享

MySQL> mysql> insert into MySQL.user(Host,User,Password,ssl_cipher,x509_issuer,x509_sub  
ject) values("localhost","pppadmin",password("passwd"),'','',''); 
 

MySQL>create database phplampDB; 

>grant all privileges on phplampDB.* to phplamp@localhost identified by '1234'; 
 

MySQL>flush privileges; 
MySQL添加授权>其它操作

/*
指定部分权限给一用户:
MySQL>grant select,update on phplampDB.* to phplamp@localhost identified by '1234'; 
刷新系统权限表。
MySQL>flush privileges; 
*/

@>MySQL -u root -p
@>密码

MySQL>Delete FROM user Where User="phplamp" and Host="localhost";  
MySQL>flush privileges;

删除用户的数据库：
MySQL>drop database phplampDB;

@>MySQL -u root -p
@>密码

MySQL>update MySQL.user set passwordpassword=password('新密码') where User="phplamp" and Host="localhost";  
MySQL>flush privileges; 

MySQL>show database; 

MySQL>use '数据库名';

MySQL>show tables; 

MySQL>describe 表名; 

MySQL>drop database 数据库名; 
MySQL>drop table 数据表名;