From: julian <jkbowler@...>
Date: 2006-03-28T19:58:55+09:00
Subject: using mysql client to read a file to create a table in a database in a mysql server

I have a little tech problem:
I have a lap top running xp home service pack two
and I have installed ruby 1.8.2 and rails 1.0.0 I also have mysql
4.1.16-nt via tcp/ip running on the laptop, so all three pieces of
software are on the laptop.

Background :this version of mysql comes with a client, but
unfortunately the client does not talk to the server in its standard
configuration because the mysql server has enhansed security, so the
new style passwords are not understood if the client uses them, (which
it does by default). any way as you are may be aware you can change the
password so that the client can connect to the server... but that's
another story...
I have used SciTE to create a file called create .sql , this file is a
number of lines of sql to create a table. Now ordinarilly I would
create a table using Mysql Query browser to issue some lines of sql to
create the table making sure I use the correct datasbase of course, but
this time I am wanting to use the mysql client to execute the code in
the create.sql file which is in the db directory of my rails
application.
so i type from the prompt
mysql depot_development <db/create.sql return
depot_development is the the database I want to put the table into, and
it was created previously by me.
I get back:
ERROR: 1045 <28000>: Access denied for user 'ODBC'@'localhost' <using
password: NO>
mysql error messages are sometimes confussing-- I think??
I wonder what's going on, can any one help me please ta v much
Julian K Bowler