Page 1 of 1

Simple connection to DB problem

Posted: Wed Mar 22, 2006 6:40 pm
by sleepwalker0
I get this error

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: YES) in C:\wamp\www\learning php\db_connect.php on line 12
Access denied for user 'ODBC'@'localhost' (using password: NO
My PHP MyAdmin setting to root was


Code: Select all

[b]
User   Host          Password    Global privileges   Grant [/b]
root    localhost   No               ALL PRIVILEGES    Yes
and finally my code is

Code: Select all

<?php

//connect
$username = "root";
$password = "";
$connect = mysql_connect('localhost',$usermame,$password)
or die (mysql_error());
echo 'Connection Established';

// database select
$database = 'videocrate';
mysql_select_db($database) or die (mysql_error());
echo 'database chosen';

?>
Any ideas why?

PS what is ODBC, I didnt include it in my code...

Posted: Wed Mar 22, 2006 7:42 pm
by feyd
look very closely at your variables names.

This is why I always recommend programming with E_ALL set for error reporting.

Posted: Wed Mar 22, 2006 8:12 pm
by sleepwalker0
It works now! Thanks your my php jesus :lol: