phpmyadmin

From: Date: Thu, 10 Jul 2008 14:22:21 +0000
Subject: phpmyadmin
Groups: php.general 
Request: Send a blank email to php-general+get-276582@lists.php.net to get a copy of this message
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

« previous php.general (#276582) next »