connection problems

[turbo99]

I have successfully made a connection to mysql server but am unable to connect to the database.

I am looking for some troubleshooting solutions.

What are the typical problems connecting to a db and how to I correct them?

Thanks in advance,

Alex

[Quevas]

With some code and a description of the error someone could help you better I think...

[turbo99]

ooops sorry about not posting the code I am using.

Its very similiar to this but with my own error message saying I could not connect to the db.

$db = mysql_connect( $host, $username, $dbpword );

$connection = mysql_select_db( $database, $db );

Im running my own webserver and I just want to run a site with a mysql backend.

It connects to the db server but not to the db requested.

thanx in advance,

alex

[jeremuck]

how do you know it's not selecting the db?

mysql_select_db(...) doesn't return anything.

So if you are using your $connection to test if something happened, it will fail, because $connection is probably 0.

However, if you use what you called $db to test later on, you should find it worked.

Most people call the value returned by the connection statement "dbLink" , "dbConnection".... something like that. mysql_select_db() sets some internal pointer, and should be completely transparent to you.

[turbo99]

the actual code I am using. Im just following a tutorial because I am a newbie to programming with php and mysql.

<?php

require("test.inc");

//Connect to the database server
$dbcnx = @mysql_connect("www.vanillamoon.net",$user,$pass);
if(!$dbcnx){
echo("<p>Unable to connect to the database server at this time.</p>");
exit();
}

//Select the order_items database
if(! @mysql_select_db("order_items")){
echo ("<p>Unable to locate the order_items database at this time.</p>");
exit();
}
?>

it connects to the database server then exits on the selecting of the database diplaying the could not find message.

Thx
Alex

[jeremuck]

do an

echo mysql_error();

it might provide you with some more information.

shrug make sure the database is spelled correctly

[turbo99]

I used the error function and received this message when I tried t access the db.

Access denied for user: '@sub19-180.member.dsl-only.net' to database 'jokes'

I am still trying to learn the administration of mysql, so I dont know why this is happening. I followed the instruction to set up a mysql/php environment and using root to test.

Any suggestions?

thx
alex

[jeremuck]

Access denied for user: '@sub19-180.member.dsl-only.net' to database 'jokes'

That looks like some host name or IP or something.

Is that the value you are using for $user?

Realize that your username for MySQL and for the server are different. (sorry if you already knew).

What OS are you operating on?

If you can, get a GUI administration tool.

Can you use phpmyadmin?
If you can get into that, use the same username and password for your connection.

In the file: my.ini,
you can set:
user=username
password=pass

Use those same values in your connection script.

[turbo99]

Boy this is giving me a headache... ugh

Im running windows 2000 server.

I have created a user mysqlroot@% with a password

my $user variable is 'mysqlroot'
and $pass variable is the password I set for this user.

My host is "63.105.19.180"

Im getting the access denied message
Access denied for user: '@sub19-180.member.dsl-only.net' to database 'jokes'

I have also tried the user and password in the MY.ini file and get the same results.

Quite perplexed. any further troubleshooting you can give me woudl be greatly appreciated.

thx
alex

[jeremuck]

shrug

beef up as much as possible at www.mysql.com

[[deleted]]

Try connecting as "root". If the file you are using to connect and MySQL are located on the same server the use 'localhost'.

If you are running the file from Apache on your local pc and are connecting to MySQL on a remote server the you have to set up a user called [e-mail] and give appropriate permissions.

To connect as 'root' place this file on the htdocs dir of your webserver and call it up on your browser...

<?php

// Let's rem this out temporarily
// require("test.inc");

//Connect to the database server
$dbcnx = mysql_connect("localhost", "root", "");

if (!$dbcnx){
	echo "Error occurred connecting to MySQL";
	exit();
	}

else {

// Test presence of db

$db = mysql_select_db("order_items");

if (!$db) {
echo "An error occured connecting to database\n"; // error detection
exit;
}

}

echo "All OK";

?>