I would like to use this time phpmyadmin (2.11.3) to setup for a new
user a database, which he can use to setup his own tables for his web site.
User abc should get his own database xyz.
I am not sure if I did it correct, and if it is safe to do so:
A
==
1. I created an empty database xyz (main page of phpmyadmin)
2. I added a new user on the Privileges page with:
User: abc
Host: Any (%)
Password: (yes)
Global privileges:
(Data:) SELECT, INSERT, UPDATE, DELETE, FILE
(Structure:) CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES
(Administration:) (nothing ticked)
(Resource limits:) (nothing ticked)
What does it mean so far? Can the user abc already access data of any
database?
B
==
I found "Database-specific privileges" for the user abc, where I added
the database xyz and ticked:
(Data:) SELECT, INSERT, UPDATE, DELETE
(Structure:) CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES
(Administration:) (nothing ticked)
What confuses me is that I have already some databases setup for my own
web, but none of the users has "B" attached.
Currently I am going away from a single person using the database to
allow others also to use the database.
Thanks for enlightening me.
bye
Ronald
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
