OK - MySQL is not an area I've had to bother with, but I'm trying to sort out a tranche of websites that 1&1 messed up the DNS on last week and we have take over support for. All the databases have backed up and been restored ... although after Firebird's backup and restore system having to dump the database as raw SQL ... that took a LONG time :(

Anyway I've installed the mysqli driver and that seems to be working and I've run 'test connection' in mysql workbench with what I think are the same settings in the joomla without a problem, but the website just gives "Database connection error (2): Could not connect to MySQL." I can browse the data in workbench, and changing user admin enables and disables that, but nothing seems to sort the php connection.

Can anybody think of something that I have missed in this or point me to a suitable 'newbie' guide to debugging mysql connections so I can get all these sites back on line again ... If it was Firebird I'd just have mirrored of one of my other machines and been working as the security stuff is managed in the database, by mysql seems to have layers of security that I'm missing somewhere ;)

Lester Caine - G8HFL
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to