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
database");
However this does not:
$query = "CREATE DATABASE my_db";
$result = @mysql_query($query, $connection) or die ("Couldn't create
database");
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
appreciated.
Thanks,
Kane T.
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=9070
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
