mySQL login error

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
davebryan
Posts: 13
Joined: 2015-11-06 16:19

mySQL login error

Post by davebryan » 2016-01-12 01:08

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

peebee
AppGini Super Hero
AppGini Super Hero
Posts: 356
Joined: 2013-03-21 04:37

Re: mySQL login error

Post by peebee » 2016-01-12 02:44

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.

davebryan
Posts: 13
Joined: 2015-11-06 16:19

Re: mySQL login error

Post by davebryan » 2016-01-12 21:37

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

Post Reply