I'm having a problem with MySQL. I am using my hosting at hostgator .com and it was all going well until I tried to create a database.
Here is my php (username and password excluded:
mysql_connect("localhost", "", "") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_query("CREATE DATABASE test") or die(mysql_error());
echo "Connected to Database<br />";
It connects to the server but doesn't create the database, saying access is denied. I tried using MySQL Database, the MySQL software that comes with the hosting and I managed to create the database and connect to it there but it won't let me do it through PHP!
I would like a PHP solution because I'm interested in writing CMS's. Thanks.