Connecting to mysql

Karve

I have set up the username and password for mysql as follows

username: fishing_user
password: pw

why when I run the following test code

<?php
$user = "fishing_user";
$pass = "pw";
$db = "fishing_dl";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
print "Successfully connected to server<P>";
mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
print "Successfully selected database \"$db\"<P>";
mysql_close( $link );
?>

do I get the following error

Warning: Access denied for user: 'nobody@localhost' (Using password: YES) in /home/fishing/public_html/test.php on line 11

Warning: MySQL Connection Failed: Access denied for user: 'nobody@localhost' (Using password: YES) in /home/fishing/public_html/test.php on line 11
Couldn't connect to MySQL

any ideas?

intenz

Try...

mysql_connect('localhost','fishing_user','pw') or echo 'Could not connect';
echo '<br>';
mysql_select_db('database') or echo 'Could not find database';

Karve

That gives me this

Parse error: parse error, unexpected T_ECHO in /home/fishing/public_html/test1.php on line 11

psy

i dunno where you ran that from, but with me when i run any mysql shit from my localhost (http://localhost/) i have to connect to my website

but if i upload the script to my server, i have to run it with localhost

that could be it, but if its on your server running localhost and giving you that error-> i dunno whats wrong 🙂

Karve

I can get the code to run fine on my local host on my computer... I am having problems when I try to run it on my web host.

MrAlaska

Do you have a dedicated server where you set up your own database, or are you on a shared host that manages MySql? If the latter, you may need to find out their methods of accessing your db. Some hosts you need to address the db with dot notation that includes your username, others might have other ideosyncrasies.

Karve

I ma looking into that now... I think that is the most likely reason

cheers