Checking User Permissions in MySQL
If you need to check what mysql users you currently have set, you can use the following code.
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.