Since the installatron support is pretty useless (been waiting 11 days without response) I figure maybe the trusty DA patrons might be of assistance!
Ok so, if I try to install ANY script that uses MySQL, it install fails with:
It creates the database, it creates the user, but it cannot access it. I went to shell and did a mysql -u admin_LppfEphpmy -p admin_LppfEphpmy and typed in the password, worked like a charm! But, if I do it the same way installtron is trying to access it (mysql -u 'admin_LppfEphpmy'@'localhost' -p admin_LppfEphpmy) it fails.
I looked at the database host permissions and localhost is there. Actually, it's identical to every other database setup on my box.
To me, it's the @localhost part that is causing issues, any ideas on how to fix this?
Ok so, if I try to install ANY script that uses MySQL, it install fails with:
mysql database connection failed.
host = localhost
database = admin_LppfEphpmy
username = admin_LppfEphpmy
errstr = Could not connect to admin_LppfEphpmyassword@localhost -- Access denied for user 'admin_LppfEphpmy'@'localhost' (using password: YES)
It creates the database, it creates the user, but it cannot access it. I went to shell and did a mysql -u admin_LppfEphpmy -p admin_LppfEphpmy and typed in the password, worked like a charm! But, if I do it the same way installtron is trying to access it (mysql -u 'admin_LppfEphpmy'@'localhost' -p admin_LppfEphpmy) it fails.
I looked at the database host permissions and localhost is there. Actually, it's identical to every other database setup on my box.
To me, it's the @localhost part that is causing issues, any ideas on how to fix this?