mysql> describe article; //显示ertlzw库中的数据列表中的article表结构 mysql> use ertlzw; //显示ertlzw库中的内容 mysql> select * from admintable; //显示ertlzw库中的表admintable所有内容 创建用户: 可以用 CREATE USER 或 GRANT 创建用户，后者还同时分配相关权限。而 REVOKE 则用于删除用户权限，DROP USER 删除账户。
$ mysql -u root -p password:# 创建数据库mysql> create database test; Query OK, 1 row affected (0.00 sec)# 查看数据库是否创建成功mysql> show databases; +-----------------------+ | Database | +-----------------------+ | information_schema | | mysql | | test | +-----------------------+ 3 rows in set (0.00 sec)# 创建特权管理用户mysql> grant all on test.* to user1@'%' identified by '123456' with grant option; Query OK, 0 rows affected (0.00 sec)# 查看用户创建是否成功mysql> select user,host from mysql.user; +-----------------+-------------+ | user | host | +----------------+--------------+ | user1 | % | | root | 127.0.0.1 | | debian-sys-maint | localhost | | root | localhost | | root | server | +------------------+-----------+ 5 rows in set (0.00 sec)# 查看用户权限mysql> show grants for user1; +----------------------------------------------------------------------------------------------+ | Grants for user1@% | +----------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'user1'@'%' IDENTIFIED BY PASSWORD '*6BB...2CA2AD9' | | GRANT ALL PRIVILEGES ON `test`.* TO 'user1'@'%' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) GRANT insert, update ON testdb.* TO user1@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; CREATE USER user2 IDENTIFIED BY 'password'; 分配权限: GRANT select ON testdb.* TO user2; 查看权限: SHOW GRANTS FOR user1; 修改密码: SET PASSWORD FOR user1 = PASSWORD('newpwd'); SET PASSWORD = PASSWORD('newpwd'); 移除权限: REVOKE all ON *.* FROM user1; 删除用户:DROP USER user1; 数据库列表: SHOW DATABASES; 数据表列表: SHOW TABLES; 当前数据库: SELECT DATABASE(); 当前用户: SELECT USER(); 数据表结构: DESCRIBE table1; 刷新权限: FLUSH PRIVILEGES;
