Testing privileges for PHP script's MySQL user

Question

I am making a website that I expect to be hosted on several servers. I want to be able to check to make sure the MySQL user that has been created on those servers has sufficient privileges so that I can give a clear error if one of the privileges that the MySQL user requires is missing.
I found the MySQL command SHOW GRANTS FOR CURRENT_USER but its output looks like it would require a bunch of work to parse.

Is there a better way to verify that the MySQL user has sufficient permissions?

Doesn't necessarily need to be in PHP. If there is a good solution with MySQL that is fine too, just not in Perl or Python or something preferably. — 1000000000
– 1000000000, Commented Feb 14, 2014 at 3:45

Nagaraj S · Accepted Answer · 2014-02-14 03:45:33Z

1

Hi try using the select statement below instead of SHOW GRANTS.

SELECT * FROM mysql.user WHERE USER LIKE 'root';

edited Feb 14, 2014 at 3:45

Nagaraj S

13.5k6 gold badges36 silver badges53 bronze badges

answered Feb 14, 2014 at 3:44

JMWORX

482 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JMWORX Over a year ago

this can be done if the user has an access to the mysql database.

1000000000 Over a year ago

Sorry, is it possible to get privilege information like that but just for one table as that command does not give any info about database level privileges

Marc B Over a year ago

there's multiple tables in mysql.* that contain the global-, db-, and user-level privileges. you'll have to query them all to see what a user's REALLY got granted to them.

Collectives™ on Stack Overflow

Testing privileges for PHP script's MySQL user

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related