Connect to DB - Total noob question...

[Signpost]

Hi all,

I am trying to connect to my DB on a hosted site. I am using this code

$host="localhost"; // Host name
$username="test"; // Mysql username
$password="group11"; // Mysql password
$db_name="jer_test"; // Database name
$tbl_name="members"; // Table name

but it keeps giving me this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/jer/domains/MYURLHERE/public_html/checklogin.php on line 9
cannot connect

Any ideas how to fix this? I can post my code if need be

[sneakyimp]

You haven't shown the code that actually tries to connect to the database. That would probably be on line 9 of the file checklogin.php

[Paavero]

$username="test"; // Mysql username
$password="group11"; // Mysql password

vs.

'apache'@'localhost' (using password: NO)

...would indicate that the mysql_connect() function isn't being passed the variables at all. The error should be 'test'@'localhost' (using password: YES) or some such.

[djjjozsi]

learn this formula:

<?php

$hostname='***'; //// specify host, i.e. 'localhost'
$user='****'; //// specify username
$pass='****'; //// specify password
$dbase='****'; //// specify database name
$connection = mysql_connect($hostname , $user , $pass)
or die ("Can't connect to MySQL") or die(mysql_error());
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");
?>

$tbl_name is not the part of the connection, but the select.

Hello,jjozsi.

[shawty]

If the user name is still showing as 'apache' then it's almost certain that the variables your passing to mysql connect are not getting through.

If your sure the variables are populated, and the varnames have no spelling errors, then it's highly likley that the mysql user table does not have an entry in it for your user name connecting from local host, in which case you'll need to contact the server administrator to have the user name added.

Another common reason for not connecting is when the DB is on a different host, EG:

dbserver.mynetwork.com

if referenced as mysql_connect('dbserver','user','pass') then it will likley fail as the user name in the mysql users table will be '[e-mail]'

Cheers

Shawty