Jump to content
Updating IPB tonight Read more... ×

Archived

This topic is now archived and is closed to further replies.

EKINdesigns

MySQL User Permissions?

Recommended Posts

Hey guys. How can i get the current users mysql permissions?

I connected to the database.

Should i run a query?

Help is much appreciated!

Share this post


Link to post
Share on other sites
You would need to run a SELECT statement on the [i]mysql[/i] databases [i]user[/i] table.

Share this post


Link to post
Share on other sites
OK thanks...thats what i thought, ill give it a try.

I get an "Access denied for user: 'user@localhost' to database 'mysql'"

Share this post


Link to post
Share on other sites
More than likely you need to be root (or maybe mysql) to login to the [i]mysql[/i] database.

Share this post


Link to post
Share on other sites
I guess you can know the privileges by "trial and error", what means, executing queries and see what happens.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.