5,576
edits
Changes
Jump to navigation
Jump to search
Line 486:
Line 486: + +
→Other useful MySQL commands:
SELECT user FROM mysql.user;
SELECT user FROM mysql.user;
display a list of the MySQL users
display a list of the MySQL users
DROP USER 'jeffrey'@'localhost';
remove the user jeffrey
SHOW GRANTS FOR 'user'@'localhost';
SHOW GRANTS FOR 'user'@'localhost';
list the privileges granted to the account user
list the privileges granted to the account user