Results 1 to 4 of 4
  1. #1

    Question PHPmyAdmin + My SQL

    Hi
    I have My SQL DB installed on my Win2k server with PHPmyAdmin. And I am unable to give user privileges to add databases and users. I will be able to add users but that user can see every database on it ( LocalHost) So I want restrict that user for adding his databases and his users.


    pls tell me how to do it,

  2. #2
    Join Date
    Dec 2001
    Location
    Melbourne, Australia.
    Posts
    208
    Have you tried just applied the 'global' create permissions, w/o select permissions?

    What global permissions do you give to uses by default?
    www.quost.com - Quost WebHosting
    www.mythellaneous.com - Mythellaneous - A shop selling a Collection of Mythical Creatures and Spooks.

  3. #3
    Oh... I have no idea about how to add 'global' create permissions, w/o select permissions??

  4. #4
    Join Date
    Dec 2001
    Location
    Melbourne, Australia.
    Posts
    208
    When you create a new user in PHPMyAdmin (the Any host - Any user page), the permissions that you set here are applied to all the dabases, I called these 'global permissions'.
    So I'd try just adding the create permission and nothing else.

    After you click on the 'grants' link for the individual user account, you can set specific permissions for the individual databases.
    www.quost.com - Quost WebHosting
    www.mythellaneous.com - Mythellaneous - A shop selling a Collection of Mythical Creatures and Spooks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •