From: Avatar <jacob.ohara@...>
Date: 2006-03-28T20:53:55+09:00
Subject: Re: using mysql client to read a file to create a table in a database in a mysql server

appologies there was an error in my last post anyway.

 ERROR: 1045 <28000>: Access denied for user 'ODBC'@'localhost' <using
password: NO>


your mysql seems to be setup to not allow un auth' d action


you say you tried the command "mysql depot_development <db/create.sql
return"

instead try

"mysql -u <your username here eg. root> -p depot_development
<db/create.sql return"

you should then be prompted for the password the account specified.

eg.

    avatar:/usr/local/mysql/bin root# ./mysql  create.sql
i receive the same error as you

    ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using password: NO)

however if I use:

    avatar:/usr/local/mysql/bin root# ./mysql -u root -p create.sql

I get promted for the password:

    Enter password:

please try this, if this still does not ork i shall try to help you
further.