ID: 9070
User Update by: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: MySQL related
Description: Can only create "test" databases.

This was not a PHP problem, but rather a configuration problem with MySQL.  I had not 
configured my username to permission to create databases.  MySQL then limited me to 
creating databases which began with the word 'test'.  For more information see the 
MySQL 'manual.html' file.  (Do a search for "starting with 'test'" and you should find 
it pretty fast). 

Previous Comments:

[2001-02-02 07:06:13] [EMAIL PROTECTED]
I cannot seem to create a database unless it begins with the word "test" in it's name. 
 However I am able to make any database I feel like when using the MySQL shell 
directly.  The following works:

        $query = "CREATE DATABASE test_user_again";
        $result = @mysql_query($query, $connection) or die ("Couldn't create 

However this does not:

        $query = "CREATE DATABASE my_db";
        $result = @mysql_query($query, $connection) or die ("Couldn't create 

Nor does any other name I use unless it begins with "test". I've tried using the 
'mysql_create_db' function with the same results.  Any help would be greatly 

Kane T.


Full Bug description available at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to