5,576
edits
Changes
From SME Server
Jump to navigationJump to search→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
