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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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 !!