Page 1 of 1
mySQL login error
Posted: 2016-01-12 01:08
by davebryan
I have my site working on localhost and uploaded it using Filezilla following the instructions in the Screencast "How to upload your AppGini web application to a web server using FTP and cPanel". When I go to the site, the AppGini site loads but when it accesses mySQL I get the error " Access denied for user 'root'@'localhost' (using password: NO)". I also tried setting up a mySQL database using the CPanel mySQL Wizzard first, but that didn't help.
How do I get rid of the mySQL login/password from localhost?
Thanks,
Dave
Re: mySQL login error
Posted: 2016-01-12 02:44
by peebee
Sounds like you've uploaded the original config file you were using on localhost, which has the incorrect database credentials for your new database.
Try deleting config.php, then navigate to your Appgini app homepage where you should be redirected to ./setup.php and a warning that you have no config file in your application.
Read, follow the prompts and enter all of the details for the new database you created in the spaces provided.
Alternatively, you could edit the the config.php file that you uploaded but it is quicker/easier using the process above - and particularly if the new database you created doesn't yet contain the generated tables/field/indexes as the process above will do all of that for you.
Re: mySQL login error
Posted: 2016-01-12 21:37
by davebryan
Peebee,
Thanks for the quick reply. Sorry mine took so long - I was out of town.
I figured the problem was some kind of configuration, but didn't know how to fix it. The fix was simple and I should have figured it out on my own. Your explanation was great and solved the problem.
Thanks,
Dave