database

[alienmojo]

im trying to connect to a database and i am getting this

Access denied for user ''@'localhost' to database 'realestate'

[steviez]

have you entered all the information in the settings correctly? username, password, server etc

[mbtaylor]

is your database username really 'user'?

 

Check your connection details

[Balmung-San]

The error looks to me like you're trying to connect with no username, or that the username you're using does not have permissions to access that database.

[Iron Bridge]

Try using something like this:

 

$DBhost = "myserver.com";   // Replace myServer.com with the url (without http://) for your Database Server
$DBuser = "myLogin";                   // Replace myLogin with your login
$DBpass = "myPassword";             // Replace myPassword with your password
$DBName = "myDataBaseName";   // Replace myDatabaseName with your DB name
$table = "myTableName";             // I think you get the idea 
   
// Connect to mySQL Server
$DBConn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error1 in Guest List Application: " . mysql_error());
// Select mySQL Database
mysql_select_db($DBName, $DBConn) or die("Error2 in Guest List Application: " . mysql_error());

[alienmojo]

well im thinking that i dont have permission to do access the database because my connect is working (im not connecting as user and im not sure why its saying that) but anyway i have if statement testing the connection on the mysql-connect and mysql_select_db it its having a problem with the mysql_select_db