Can't select new DB ??

Anon

I created a new DB this morning called "MyDB" and put a test table into it. Then I tried to connect to this new DB using a PHP script. The script was able to connect to the DB -- but kept saying it could not "select" it.

I also made sure I issued the "mysqladmin flush-privileges" command from the monitor.

The PHP script is as :

$db_name = "MyDB";

$conn = mysql_connect("localhost", "myname", "pword") or die ("Couldn't connect.");

$db = mysql_select_db($db_name, $conn) or die ("Couldn't select database.");

I also issued the "use MyDB"; command from the monitor.

I am out of ideas on this one. I am using the latest MySql download, and running on Win Me. And I've even rebooted the machine, just to be sure.

This same script, however, is connecting with my other testDB.

Anon

double check and double check again your user and passwords

Anon

Yep, did that. I just don't get it. The script just will not select the new DB, even tho I can see it via the MySql monitor and all that.

Somehow I think I must still be running "crippleware."

I'm almost beginning to wonder if MySql has sort of borrowed a page out of the FORTRAN playbook, by limiting the names of new DBs to the letters T thru Z.