Results 1 to 4 of 4
Thread: PHPmyAdmin + My SQL
-
01-17-2003, 09:44 AM #1Web Hosting Master
- Join Date
- Oct 2002
- Posts
- 894
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,
-
01-17-2003, 10:28 AM #2Junior Guru
- 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.
-
01-17-2003, 10:36 AM #3Web Hosting Master
- Join Date
- Oct 2002
- Posts
- 894
Oh... I have no idea about how to add 'global' create permissions, w/o select permissions??
-
01-18-2003, 01:20 AM #4Junior Guru
- 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.