Jump to content


Photo

User Permissions


  • Please log in to reply
1 reply to this topic

#1 Jonathan

Jonathan
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationUnited States

Posted 30 December 2003 - 06:39 PM

How can you protect your database by user permissions. I am looking for a way to do this via PHPMyAdmin

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 30 December 2003 - 11:05 PM

Mysql has a data dictionary which is a database called mysql. If you can use that database, you can set permissions for individual users by using the grant statement (which also allows you to create users). I have a few examples in a mysql section of the tech page off my homepage. Link is in my sig.

If you are in a hosted environment, chances are you have had a database user created for you, and will not have access to the mysql database.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users