How To Test Mysql Database Connection

Forums » Php »» How To Test Mysql Database Connection

Sun Nov 08, 2009 10:19 am - How To Test Mysql Database Connection

#2690

Hello,

Welcome to Webune Support Forums - We provide PHP hosting with MySQL database. Our support and service is umnatched. we are delelopers 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 unseccessful.

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

Attachments

NOTE: You MUST be Logged in to be able to download this Attachment.

testmysql.zip

(2 KB) - Downloaded 37 Times

Safe Download: 0 Viruses Found
More Info...

author: Webune Tutorials

Share this post by copy and paste this URL and put it on your forums or use it on your profile like myspace, friendster, Facebook, Twitter or others and add in with your comments.

Use this HTML code to embed this topic, just copy the code from the "Embed" box. Once you've copied the code, just paste it into your website or blog to embed it.

BBCODE is use on forums. You can put this code on all your BBCODE enabled forums like PhpBB, vBulletin® and others. Just Copy and Paste this code on with Posts and Replies on your forums

Thu Nov 05, 2009 6:53 pm - Re: How To Test Mysql Database Connection

#2723

harshir

i specialize in upgrading to fm pro 10, if you are interested let me know and i can do the migration for you very cheap. i am in india and i urgent need of a it job.

Fri Nov 06, 2009 5:45 am - Re: How To Test Mysql Database Connection

#2724

haritha

hi,
this my first attemp

Sun Nov 08, 2009 1:25 am - Re: How To Test Mysql Database Connection

#2751

Rosa

grazie!! almeno son riuscita a connettermi al db!

Fri Feb 05, 2010 6:53 am - Re: How To Test Mysql Database Connection

#3418

bbb901

im interested in putting code inside the database tables can you execute code from the database itself into your scripts?

Mon Feb 22, 2010 5:55 pm - Re: How To Test Mysql Database Connection

#3506

Volkner

i passed the test, but when i try the following php script, i don't get any errors (it successfully outputs), but i don't get any output...

<?php
$username = "cameron";
$password = "{password}";
$database = "employees";

print $database;

mysql_connect('localhost',$username,$password) or die ("failure");
 - at - mysql_select_db($database) or die( "unable to select database");
$query="select * from employeeinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>database output</center></b><br><br>";

$i=0;
while ($i < $num) 
{
	$first=mysql_result($result,$i,"lastname");
	$last=mysql_result($result,$i,"firstname");
	$id=mysql_result($result,$i,"employeeid");

	echo "<b>$first $last</b><br>id: $id<br>";

	$i  ;     
}

die();
  
?>

Tue Mar 09, 2010 8:51 pm - Re: How To Test Mysql Database Connection

#3587

vijayanand

thanks, the script was very useful. it helped us diagnose the problem and connect to the database.

Tue Mar 30, 2010 3:36 pm - Re: How To Test Mysql Database Connection

#3673

Gary

i need help.

can someone help me since i am getting an error "php has encountered an access violation ..."

i have no idea. i ran the above script and i just get this error.

can you help?
email: ggordon - at - garymgordon

thanks,
gary

Tue Mar 30, 2010 4:50 pm - Re: How To Test Mysql Database Connection

#3675

webune

Re: php has encountered an access violation

this means you dont have permissions.

make sure you entered the correct username and password for you database connection

Testing Mysql Database Connection Script