I am trying to install/test Amember to see if I want to buy it and I cannot get the trial to install. 1. I ran the tester and uploaded the right version (ION) to the root of my site. 2. I created a brand new MYSQL database called amember with the user of "admin" and I noted the password and host name. 3. When I try to configure amember, this is the error I get every time: Cannot select database 'amember' (Access denied for user 'admin'@'localhost' to database 'amember') I made 100% SURE that the database name, user, password, and local host were all correct and that all privileges were enabled. I even deleted the db and created a new one and tried a different name and still get the error message. Why is this happening and how can I get amember to work? P.S. My host is Hostgator.
Thanks for the reply. I just went back in and still no luck. I deleted the db and created yet another new one named "amember" and it's on local host and I put the username and pw correct that I created and still the same error message. It's definitely not having the wrong information. I have done it 10 times and made sure all was correct and exact. Here are the other factors, could they matter? *Hosting main account is setup on one of my domains for example mydomain1.com but I installed amember on mydomain2.com/amember which is controlled under the same hostgator hosting acct but isnt the main account. I also have a blog on it with databases..the blog is on mydomain2.com/blog Don't know what else to try. It's the right information I am putting in.
This error: Code: Cannot select database 'amember' (Access denied for user 'admin'@'localhost' to database 'amember') means that the problem is user permissions. login/password is ok. But user can't access database. Make sure that in your hosting CP you add this user to database access list.
Thanks for trying but I guess it just isn't going to work. I have made sure to create the user and database, give the user full access and all privileges to that database, and spell the username, pw, database, and host name correct. I have tried deleting the user and database and doing fresh ones, different names, etc, and I still get the same error message every time.
have you contacted support@hostgator.com yet? seems they would be a faster path to get your connectivity / credential issue sorted as this is most likely not an amember specific issue. My first guess though, is that I'm surprised they are letting you use an id of 'admin' for your mysql username.. According to this hostgator faq: http://support.hostgator.com/articles/cpanel/how-to-connect-to-the-mysql-database
Ahhhhhh, you nailed it, thank you. I looked at the link you provided and the problem was that I did not realize that I had to put my cpanel username and an underscore before the DB and user name. Once I did that it worked. Thanks guys!