MySql has beaten me to a pulp

[ghammer]

G'Day active Apachies, MySql has beaten me into submission, so I'm rolling over, crocodile, and I give up.
Just a bit of background on me, I'm an ex VMS, Unix sys5, BSD4.3, Aegis, cpm, dos and a few graphics languages ex techo and I'm embarassingly stumped. I have loaded XAMPP v 5.1.14 and can get everything to run except the cdcol demo. I can start a Mysql session from a cmd shell by issuing mysql -u root --password='xxxxxxx' and it works and I can then look at the databases and issue commands but I cant run the cdcol demo and I cant go forward with my plans until I nail that.
This is the error message.


Could not connect to database!
Is MySQL running or did you change the password?


I have tried a lot of approaches but am still stumped can someone please help
Take care ghammer

[Nobbie]

but I cant run the cdcol demo and I cant go forward with my plans until I nail that.
This is the error message.


Could not connect to database!
Is MySQL running or did you change the password?

Yes of course, this is simply true, as you changed the "root" password.

I have tried a lot of approaches but am still stumped can someone please help
Take care ghammer

You are really an experienced programmer?? It took me 1 minute to find out:

a) that the cdcol demo is a PHP script which is stored in htdocs/xampp/cds.php
b) that it trys to connect with "root" and empty password into mysql
c) to insert a single line which provides the right password (i changed it as well in order to answer your question)

Code: Select all

    ...
    $mypasswd = 'xxxxxxx';  // <--- simply insert this line in cds.php, replace 'xxxxxxx' by the password

    if ($_REQUEST['action'] == "getpdf") {
    ...

And that's it.

[ghammer]

Thank you I'll give it a run.
Take care ghammer

[ghammer]

Hi Nobby I can't stop laughing at your reply, but I know your on the money so thanks so much.
I want you as a friend ghammer