Sunday, February 17, 2013

Troubleshooting MySQL user permissions

SELECT user(), current_user();
user() -> connection info of user
current_user() -> user that will be compared with privileges

SELECT user, host FROM mysql.user WHERE user='<the_user>';

No comments: