This is more of a SQL question that PHP. If you want to grant all privileges to abc to database xyz (minus GRANT), you should run these queries: CREATE DATABASE xyz; GRANT ALL PRIVILEGES ON xyz.* TO 'abc'@'somehost' IDENTIFIED BY 'somepassword'; -----Original Message----- From: Ronald Wiplinger [mailto:ronald@xxxxxxxxx] Sent: Thursday, July 10, 2008 9:22 AM To: php-general@xxxxxxxxxxxxx Subject: phpmyadmin 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
