Test MySQL database connection with php script

You can use the following php script which is used to test mysql database connection on your cpanel server.

<?php
$link = mysql_connect('db_host', 'db_username', 'db_password');
if (!$link)
{
die('Could not connect the database: ' . mysql_error());
}
echo 'Database Connected successfully';
mysql_close($link);
?>

db_host : Mostly used ‘localhost’ when you connect on the same server.

db_username : Use your test database username.

db_password : Use your test database password.

The above MySQL connection test script is using mysql_connect(); function which is designed to open a connection to a MySQL Server.

0 Bu dökümanı faydalı bulan kullanıcılar:

Diğer Dökümanlar

How to Install Perl DBD::MySQL
This problem may occured when trying to install the perl-DBD-MySQL. It is found out the problem was came from MySQL issue where you have upgrade the MySQL from 5.0 to 5.1. To overcome the issue,...
cPanel security settings checklist
You always use cpanel recommended Security Settings to avoid hacking and other suspicious activity. These cPanel Server Hardening & Security tips will help prevent from hacking. cPanel...
sendmail Not running with correct effective GID
Wed Sep 04 04:11:11 2014] [error] [client 11.44.33.22] sendmail: Not running with correct effective GID. Is sendmail binary setgid mailtrap?, It may be the problem with your sendmail binary...
How to enable NAT behind the cpanel ?
Most of webhosting providers currently used NAT service for their users. When you install cPanel & WHM, the installer will detect whether your server is on a NAT-configured network. If the...
Unable to allocate memory for pool
Warning: Unknown: Unable to allocate memory for pool. in Unknown on line 0 APC or Alternative PHP Cache (APC) is a free and open opcode cache for PHP. APC allows for caching of opcode generated...