青岛农业大学动漫与传媒学院网站创建与管理课件 第22章.pptVIP

* 返回 “显示信息”操作—show table status * “显示信息”操作—EXPLAIN实例1 * 返回 “显示信息”操作—EXPLAIN实例2 * 返回 “用户权限管理”—增加账号 mysqlCREATE USER 用户名 IDENTIFIED BY 口令 mysqlGRANT ALL PRIVILEGES ON *.* TO user1@localhost IDENTIFIED BY ‘pass1’ WITH GRANT OPTION; mysqlGRANT ALL PRIVILEGES ON *.* TO user1@”%” IDENTIFIED BY ‘pass1’ WITH GRANT OPTION; mysqlGRANT RELOAD, PROCESS ON *.* TO admin@localhost; INSERT INTO user VALUES(‘localhost’,’user1’,PASSWORD(‘pass1’)); 权限有：select,create,insert,update,delete … 更改用户密码 C:MySQLadmin [-u 用户名] password 新口令 Mysql SET PASSWORD=