Here's the code I'm using. Have done this before without a problem until the phpMyAdmin was upgraded to 2.3.2 with MySQL 3.23.53a . Now when I try creating a new database I can't connect. The existing ones are working fine though. Just the new ones aren't working.
$db = mysql_connect("localhost","user","password")
or die("Could not open connection to database");
echo "First Line of database connection works <BR>";
mysql_select_db("database",$db)
or die("Unable to select the database.");
I keep getting:
"First Line of database connection works
Unable to select the database.
OK, it's giving me an "Access Denied" for my user name with this database.
Could it be something with teh permissions. Ive already tried those settings with no results so far
Or in phpMyAdmin just go to the index page then click the users link and then the grants link next to your username. From here you can setup the privileges for that user.