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 ?