I am moving the library to it's new home but I am having a few problems talking to mysql. mysql --host=localhost --user=opendb --password=thepassword Works, I can then see a database called aluglib and run queries on the tables etc. In my opendb config.php I have // Database configuration $CONFIG_VARS['db_server.host'] = 'localhost'; //OpenDb database host $CONFIG_VARS['db_server.dbname'] = 'aluglib';//OpenDb database name $CONFIG_VARS['db_server.username'] = 'opendb'; //OpenDb database user name $CONFIG_VARS['db_server.passwd'] = 'thepassword'; //OpenDb password But when I try and login to the Library I get the following error Access denied for user: 'opendb@localhost' (Using password: YES) Not being very experienced with these things, can anyone give me some pointers to what I am doing wrong. To move the library I simply dumped the old database and then imported that into the new one with mysql blah blah databasename < dump.sql. the rest of the site was just coped over using scp. Then I just changed the config in config.php and checked permissions. I thought that should be it ?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Wayne Stallwood <ALUGlist@digimatic.plus.com> wrote: <snip />
// Database configuration $CONFIG_VARS['db_server.host'] = 'localhost'; //OpenDb database host
OK - try changing that to 127.0.0.1 instead of localhost, there's a possibility that it's having 'issues' and is trying to use the unix socket rather than a TCP connection, and that it's failing to get the unix socket. - -- Brett Parker web: http://www.sommitrealweird.co.uk/ email: iDunno@sommitrealweird.co.uk -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFDR/fxEh8oWxevnjQRAhTSAJ9l0SQYmmtuXH/S2ObiUzygAEyjDgCgjbap HcOmbTfmAib99ZtWAClivbw= =qFG+ -----END PGP SIGNATURE-----
Not being very experienced with these things, can anyone give me some pointers to what I am doing wrong. To move the library I simply dumped the old database and then imported that into the new one with mysql blah blah databasename < dump.sql. the rest of the site was just coped over using scp. Then I just changed the config in config.php and checked permissions.
I thought that should be it ?
use localhost:/tmp/mysql.aluglib you have your own instance of MySQL hence you need to use the MySQL socket Regards Darren
participants (3)
-
Brett Parker -
Darren -
Wayne Stallwood