Hi Happy New Year to you all. Over the past couple of days i have been moving my sites to a new server with the same host company. The support saff have been great and did most of the work for me. I have started testing to make sure everything works but have had a problem adding a database user. I have the listmail plug-in and the database user name for the list mail database (for amember to add people to a listmail list) and the amember database are the same. This was not a problem before but on the new server it is not letting me have two users with the same name, even though they are for different databases. I assume this is what is giving me the following error? MYSQL ERROR: SELECT command denied to user 'ccpykfyn_am'@'localhost' for table 'lm_lists' in query: SELECT listnum, title FROM ccpykfyn_mail.lm_lists What do i need to do to change the database name so that amember will add members to my listmail list again? Thank you in advance. Paul
You can set your database config for listmail in its config.php file. You can then configure the plugin via aMember in the setup/config.
Go into your amember admin / plugins / listmail, and set up the new database info. You may also need to go into your cpanel and add the amember user to the listmail database. David