Page 1 of 1

MySql has beaten me to a pulp

PostPosted: 02. April 2010 06:22
by 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

Re: MySql has beaten me to a pulp

PostPosted: 02. April 2010 11:42
by Nobbie
ghammer wrote: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.

ghammer wrote: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.

Re: MySql has beaten me to a pulp

PostPosted: 02. April 2010 12:00
by ghammer
Thank you I'll give it a run.
Take care ghammer

Re: MySql has beaten me to a pulp

PostPosted: 02. April 2010 12:11
by 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