PHP 4.0 Bug #9070 Updated: Can only create "test" databases.

ID: 9070 User Update by: kane@idworld.net 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] kane@idworld.net 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