I created the mysql database using hostgators cpanel. Database name used is amember and the database prefix was supplied by MySQL. Added a user and passwd with all privileges. Everything seems to be submitted correctly in step 2 of 4 but an error comes back "cannot connect to mysql for the user that was setup. What could I be doing wrong?
You might have called your database 'amember' but check back in 'Cpanel' and you will probably find the database is called 'xxxxx_amember' as something like the Cpanel user name and a '_' will prefix your db name.
mysql data base is xxxxxxxx_amember. (the x's represent the prefix that cpanel adds for you when a mysql db is created. My inputs to step 2 are: localhost amember myusername for the mysql db mypassword for the mysql db xxxxxxxxxx_ As far as I understand the instructions for step 2 that would be the correct inputs. However I cannot connect to mysql.