Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

Shows all Users Privileges:

select * from information_schema.user_privileges;

Shows Users:

SELECT User FROM mysql.user;
SELECT * FROM mysql.user \G

Show grants for user:

show grants for 'root'@'localhost';

Grant ALL Priv:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'PWD'
  • No labels

1 Comment