If you cannot connect to MySQL server, there could be some causes:
- Incorrect MySQL hostname.
Always use 'localhost' as your MySQL hostname. You can find your MySQL details by logging in to your 000webhost account, selecting website, then go to “Manage database” tab. - Incorrect MySQL username / password or database name.
If you want to create, delete or edit your database, go to 'Manage Database' tab inside your Control Panel (Members' area). If you want to change your database password go to 'Manage Database' -> 'Manage' dropdown -> 'Change Password'.
- Database failed to setup.
In a very rare cases MySQL database can fail to setup. To confirm this, please try to enter phpMyAdmin for any database. If you see database there, that means its setup was successful. And if you get access denied error by trying to enter phpMyAdmin, please delete the database and setup the same MySQL database again.
Please note that you must give about 1 minute for any changes to apply on server.
If you are still unable to connect to MySQL you can check if it's server or your scripts' problem: if you can enter phpMyAdmin and see you database there, that means everything is working fine on our side. It's a problem with your PHP script.
Upgrade to Premium Hosting to get Unlimited MYSQL database. We also promise 24/7 LIVE support, all your questions will be answered in hour or less. Find out more at www.hostinger.com