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 <db/create.sql -- simply works !!
2. Another way as people suggested to make it work was to give permissions
to user ODBC. I was not being able to do this earlier(as i had mentioned in
my mail that i could give permissions to new user) but I figured out
later(thanks to Martin's link !!) that the problem was due to the "enable
strict mode" option which I had checked in during installation. So, for a
shortcut, I simply uninstalled and re-installed MySQL, this time with this
option, and I could now add new users !!
Also now, I did not need use [1] to access the db/create.sql file, my
earlier command works fine

Thanks again for the support !!
Kapil

On 7/9/07, Jerry Schwartz <jschwartz@the-infoshop.com> 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 default
> is
> ODBD@localhost.
>
> You need to use the -p and -u options on the command line.
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>
>
>
>
>


--
I can sum up everything i learned about life in three words -- IT GOES ON !!