My website is working but unable to fetch the data from MySQL database

There are many reasons due to which you are unable to fetch the data from your MySQL database. Following are some common causes for this to happen:

Cause 1:

Incorrect database login credentials. It is possible that database login credentials are changed but not updated in the connection string of the config file.

Fix:

You can open your config file, collect the password and reset it for your database user.

Cause 2:

MySQL service is down/unresponsive. When the website is having too many concurrent connections or bumped with lots of traffic.

Fix:

Please restart the MySQL service to fix it.

Cause 3:

Database table corruption. Sometimes table corruption can result into a database connection error.

Fix:

You can repair the corrupted table from cPanel/phpMyAdmin.

Above mentioned are the common causes. However, if you face any error other than these, you can contact us to diagnose it further. Please raise a support ticket.

  • 0 Users Found This Useful

Was this answer helpful?


Related Articles

Where is the database folder for MS-Access database?

'db' folder created along with the 'www' or 'wwwroot' folder is the recommended folder for .mdb...

Can I connect to MSSQL server on two machines with the same user?

Yes, you can. But in that case, you will need to have both your PC on different network. It won't...

MS Access :: Do you have sample connection strings for DSN Less Connection and DSN Based Connection?

MS-Access Database Connection ASP code: DSN Less Connection: Dim strConnSet strConn =...

How do I place my database on your server? Will my primary keys, stored procedures and constraints be preserved or destroyed?

All you have to do is to take a full backup of your database on your local machine and place a...