Warning:mysql_connect() : Access denied for user 'ODBC'@'localhost'

mhmo

Dear All

I just installed XAMPP in my pc. I created a page to connect to MySql DB. This is the code:

<?php

$username = "root";
$password = "";
$hostname = "localhost";

$con = mysql_connect($hostname,$usename,$password) or die ("Unable to connect");
?>

But, when I go to the page I face the following Warning:

Warning: [font=Verdana]mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\dive\index.php on line 12
Unable to connect[/font]

What would be the problem and the solution?!!

Thanks

cahva

It will try to open with user ODBC which is default user if no user is set(this varies ofcourse from computer to computer but your installation it is that). You have error in the connect:

$con = mysql_connect($hostname,$usename,$password) or die ("Unable to connect");

$usename should be $username

sean300rocks

Hi Guyz

I get the same error message;

Checking server configuration.\ n
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\testoft\config.php on line 8
cannot connect to server.

Do I apply the same method as above?

Rgs

Sean

cahva

Well..Yes. 🙂 You havent set the username if it says ODBC@locahost