5、删除及重命名账户
使用drop user命令删除用户 --查看当前系统中已存在的用户 root@localhost[(none)]> select user,host,Password from mysql.user; +-------+-----------+-------------------------------------------+ | user | host | Password | +-------+-----------+-------------------------------------------+ | root | localhost | | | root | suse11b | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | | | | suse11b | | | fred | localhost | | | frank | % | *63DAA25989C7E01EB96570FA4DBE154711BEB361 | | jack | localhost | | +-------+-----------+-------------------------------------------+ --使用drop user命令删除用户 root@localhost[(none)]> drop user 'frank'@'%'; Query OK, 0 rows affected (0.00 sec) root@localhost[(none)]> drop user 'fred'@'localhost'; Query OK, 0 rows affected (0.00 sec) root@localhost[(none)]> select user,host,Password from mysql.user where user like 'fr%'; Empty set (0.00 sec) --如何重命名帐户，使用rename user命令 root@localhost[(none)]> rename user 'jack'@'localhost' to 'jason'@'localhost'; Query OK, 0 rows affected (0.00 sec) root@localhost[(none)]> select user,host,Password from mysql.user where user like 'j%'; +-------+-----------+----------+ | user | host | Password | +-------+-----------+----------+ | jason | localhost | | +-------+-----------+----------+ --对于用户的删除也可以直接从mysql.user进行删除相应的记录，但不推荐直接操作mysql系统表
?