hi,
im working from the wrox 'beginning php, apache, mysql webdevelopment' book and am having major probs with my first mysql database.

i save the code as .php:

<?
$connect = mysql_connect("localhost", "root", "mypassword") or
die(mysql_error());

mysql_create_db("wiley")
or die (mysql_error());

mysql_select_db ("wiley");

etc

...but when i run the prog in my browser, with apache running, i get the following error message (line six being the first line proper in the code:


Warning: mysql_connect(): Lost connection to MySQL server during query in C:\Program Files\Apache Group\Apache2\test\createmovie.php on line 6

Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files\Apache Group\Apache2\test\createmovie.php on line 6


bearing in mind that apache and php are all working fine and i know the password and localhost paths are correct - please could someone help me figure ot whats going on!

Thanks a million

Please can you paste line 6, to check that you are querying the database properly.

You should never ever ever try to connect to MySQL as root from a script (unless you absolutely have to - for example, to add new SQL users).

Check MySQL is running, etc etc. Try opening a shell to MySQL, and check that you can query the database okay from there.

Cheers

--
Please contact me at:
Colin (dot) Horne (at) gmail (dot) com
My blog: http://colinhorne.blogspot.com