Checking User Permissions in MySQL

Checking User Permissions in MySQL

If you need to check what mysql users you currently have set, you can use the following code. select * from mysql.user This will list out all the users. Take note to what host they can access your database from. There may be multiple entries for the same user if you limit them to a certain host, like an ip address, or localhost. To see the full permissions use the grant feature. Change localhost to an IP address if you filter by that. SHOW...

Read More