Re: MySQL and 'ODBC'@'localhost' error

2007-07-09 Thread kapil kaushik
Hi All, Thanks a lot for your help. The thing is working now. Although I would like to mention a couple of points: 1. mysql -u root -p test_dev wrote: You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the defa

RE: MySQL and 'ODBC'@'localhost' error

2007-07-09 Thread Jerry Schwartz
You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the default is [EMAIL PROTECTED] You need to use the -p and -u options on the command line. Regards, Jerry Schwartz The Infoshop by Global Information Incorporat

Re: MySQL and 'ODBC'@'localhost' error

2007-07-08 Thread Martin Gainty
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 info