Hello Im having a trouble connecting to MYSQL Serevr.
It keep saying that
"ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: NO)

It used to say "Access denied ERROR 1045: Access denied for user: myname@localhost(Using password: YES)
What shall I do

I want to reset a new user name and password so how can i do this please?
Thank you

There are a number of things that could be the problem. Have you checked to see if the server is turned on? To do this go to your mysql directory (By default it is C:\mysql) and then type cd bin. After this type mysqladmin ping. If it says something like
then the chances are the server is not turned on.

try typing "net start mysql" (If you use Windows NT, 2000 or XP) or mysqld (if you use Windows 95/98/ME.) and then repeating the mysqladmin ping command. if the server is now working it will say mysqld is alive.

Then try going into mysql again with mysql.

Coincidently it is a good idea to either set a password for user the blank user (ODBC@localhost) or remove it completely. You should also set a password for root. If you would like to know how to do this, there is an excellent tutorial at mysql website http://www.mysql.com/documentation/m...unt_Management

HTH (Hope This Helps)


---
David Thorne, Student
UK

mysqladmin: cennect to server at 'localhost' failed
error: 'Access denied for use 'ODBC'@'localhost' (using password: NO)'

The server is already started but when I try ping or try a test script it gives me the above error. HELP!!!

I was having the same problem.
Here is the code I used to connect to the database:


<?php
$db_host='localhost';
$db_database='test';
$db_username='';
$db_password='';
?>

The above script is saved as db_login.php.

<?php
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
$db_select = mysql_select_db($db_database);
if (!$db_select){
die ("Could not select the database: <br />". mysql_error());
}
?>

The above script is saved as connect.php.

And I was calling the connection.php file in localhost.Environment is as follows:
Windows XP
WAMP5 (the windows installer for php, mysql and Apache)
Firefox web browser.

Solution:

I changed the db_login.php as follows to include root as the username:

<?php
$db_host='localhost';
$db_database='test';
$db_username='root';
$db_password='';
?>

It worked.

Reason:
It uses 'ODBC' as the user instead of 'root'.
This only happens in Windows OS.

Try to include files in other way <That can be problem somethimes>.
If you included file in bad way, some var's cannot be passed to function.
For example :

include ($_SERVER['DOCUMENT_ROOT'] . '/test/db/dbconn.inc');

$_SERVER['DOCUMENT_ROOT'] returns your directory root

Stankovic Vlada