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
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
-
Brett Parker -
Darren -
Wayne Stallwood