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
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
M--
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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, July 08, 2007 4:07 PM
Subject: MySQL and 'ODBC'@'localhost' error
Hi,
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
fine:
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,
but
'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
able
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.
Thanks,
Kapil
--
I can sum up everything i learned about life in three words -- IT GOES ON
!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
