You are attempting to login as ODBC
If your scripts are using ODBC as the USER you will need to CREATE USER ODBC
and GRANT necessary privs doc available at
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
----- Original Message -----
From: "kapil kaushik" <kaushik.kapil@stripped>
Sent: Sunday, July 08, 2007 4:07 PM
Subject: MySQL and 'ODBC'@'localhost' error
> I am very new to MySQL. I have downloaded and installed the "
> mysql-essential-5.0.41-win32.msi" version for Windows XP.
> After installation and instance configuration, the following thing runs
> mysql -u root -p
> Enter password: *********
> -- gets me to the mysql prompt and the following things also work fine
> mysql> create database test_dev
> Query OK, 1 row affected <0.00 sec>
> mysql> grant all on test_dev.* to 'root'@'localhost'; (this works fine,
> 'kapil'@'localhost' in its place gives ERROR 1133)
> Query OK, 1 row affected <0.01 sec>
> (this means that the mysql server is up and running)
> I then write a small create.sql file, in the child folder db/create.sql:
> drop table if exists products;
> create table products (
> id int not null auto_increment,
> primary key (id)
> The problem now comes when i write the following command:
> cwd>mysql test_dev <db/create.sql
> It now gives me the following error message:
> ERROR 1045 <28000>: Access denied for user 'ODBC'@'localhost' <using
> password: NO>
> I have tried looking for some responses online, but most of them said that
> the problem is related to root user and password etc., but I guess I am
> to login to the mysql prompt. I also tried the following ( and got error
> cwd>mysqladmin ping
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'ODBC'@'localhost' <using password: NO>'
> Confused as to what is going on !!
> Sorry for making it too long, but just wanted to make it as clear as
> possible from my side. Any help will be most appreciated.
> I can sum up everything i learned about life in three words -- IT GOES ON