Jump to content


Photo

MySQL User Permissions?


  • Please log in to reply
4 replies to this topic

#1 EKINdesigns

EKINdesigns
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationUSA

Posted 30 May 2006 - 11:55 PM

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!

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 31 May 2006 - 12:24 AM

You would need to run a SELECT statement on the mysql databases user table.

#3 EKINdesigns

EKINdesigns
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationUSA

Posted 31 May 2006 - 05:02 AM

OK thanks...thats what i thought, ill give it a try.

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

#4 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 31 May 2006 - 05:39 AM

More than likely you need to be root (or maybe mysql) to login to the mysql database.

#5 poirot

poirot
  • Members
  • PipPipPip
  • Advanced Member
  • 646 posts
  • LocationAustin, TX

Posted 31 May 2006 - 03:16 PM

I guess you can know the privileges by "trial and error", what means, executing queries and see what happens.
~ D Kuang




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users