Page 1 of 1

Problem connecting to db

Posted: Tue Jul 07, 2020 11:31 am
by PeterFox
Hi Everyone,
just getting back into doing web stuff again and don't want to use mega serious overkill for a modest website (e.g. wordpress) so happily came back to the one and only S9Y :D
But having problems installing / connecting to MySQL database ("The mySQL error was: No connection could be made because the target machine actively refused it."):

- local setup: WAMPServer 3.2.0
- MYSQLi
- wordpress, for example, works fine with this setup
- don't think it's password problems (tried with root and others)
- only recommendation in pre-diagnosis is imagemagick not found, otherwise everything ok.

I don't want to use another database as this setup is a reflection of what will be on the live hosted package.

Any pointers would be very welcome....
Pete

Re: Problem connecting to db

Posted: Tue Jul 07, 2020 12:00 pm
by onli
If all the connection data are correct that sounds like a setup specific issue. Sadly I'm not familiar with WAMP (in general linux is used for hosting s9y). https://stackoverflow.com/questions/177 ... sed-it-php points to a lock file that might have to be removed or a restart of the apache/mysql service? It might also be an incorrect port.

There also seems to be a logfile that might contain more information.

Re: Problem connecting to db

Posted: Tue Jul 07, 2020 7:54 pm
by PeterFox
Thanks Onli for the lightning response 8) very nice.
I poked around rather a lot - somewhat frustrating - seemed to have got a bit further by specifying localhost:3308 in setup form. MySQL logs are sporadic on my setup so only helped sometimes :wink:
Now relative links don't seem to work on my setup - but that's for tomorrow.

Re: Problem connecting to db

Posted: Wed Jul 08, 2020 11:35 am
by PeterFox
Lovely. Seems to function wonderfully. Now I can start :D

Re: Problem connecting to db

Posted: Wed Jul 08, 2020 1:22 pm
by onli
Great. Have fun! :)