How To Test Mysql Database Connection

Hello,

Welcome to Webune Support Forums - We provide PHP hosting with MySQL database. Our support and service is unmatched. we are developers like you and we know what PHP developers needs.

Today we are sharing a very useful script written in php to test you database connection. this easy and simple to use script will help you confirm the login information you have been given it correct.

for example. lets say you have a script which uses a MySQL database, but you are getting connection errors like:

Access denied for user 'admin'@'localhost' (using password: NO)

this error simply means you dont have the correct database information like your username because the script tried to connect to your databse but it was unsuccessful.

if you dont want to download the script provided in this post, you can create the script yourself by following the steps provide on this post: Testing Mysql Database Connection Script


step 1. download the script provided in this post

step 2. unzip it and upload to your server where you have PHP and a MySQL database.

step 3. once you have uploaded to your site, test it by accessing the script to where you place it in your site. for example:

http://www.example.com/testmysql/test-mysql.php

please give us any comments or tips.

Thanks
Webune Support Team

UPDATE: after reading some of your replies, there are some of you that are having trouble because no errors show up. probably your PHP configuration is setup to hide errors, what you can do is add this line at the beginning of our script:

add this line:
ini_set('display_errors', 1);

this will ensure that if you have any errors, it will show up