Nub question: <db/create.sql?

Rails
1

Hello all:

I am trying to get started with ROR coming from a classic ASP
background.

I am going step by step through “Agile Web D. with Rails” isbn
0-9766940-0-x. On page 55 I am trying backup my DDL with the fallowing
code:

depot> mysql depot_development <db/create.sql

ERROR 1045 <28000>: Access denied for user ‘ODBC’@‘localhost’ (using
password: NO)

What am I doing wrong. Let me know if you need more info.

Thanks for your help

2

Ian Seabock wrote:

depot> mysql depot_development <db/create.sql

ERROR 1045 <28000>: Access denied for user ‘ODBC’@‘localhost’ (using
password: NO)

What am I doing wrong. Let me know if you need more info
You proably need to pass the correct username and password for your
install of MySQL and chosen database. Check the doco on the mysql
command to findout how to pass them in.

Cheers,

Anthony R.

3

On Sep 26, 2007, at 8:00 PM, Ian Seabock wrote:

ERROR 1045 <28000>: Access denied for user ‘ODBC’@‘localhost’ (using
password: NO)

This is a MySQL problem. See MySQL’s documentation on what’s going
wrong…

http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

Just from what you’ve provided, I would guess that your installation
of MySQL hasn’t been completed. There are steps for securing the
initial MySQL account…

http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

…and steps for creating users to access the databases…

http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

Once I secure the initial account from the command line, I prefer to
use PhpMyAdmin to do the rest, like creating databases and assigning
privileges…

You need to create the database and set its privileges before you can
run the migrations on it.

Jose

…
Jose Hales-Garcia
UCLA Department of Statistics
[email protected]

4

You can download the free mysql-administrator gui tool from mysql’s site
and it greatly simplifies adding users and delegating permissions.

5

I just used phpmyadmin to manually add a new called ODBC at host
localhost, with all privileges, and no password. Then the “mysql grant
all…” command worked.

On Sep 26 2007, 11:00 pm, Ian Seabock <rails-mailing-l…@andreas-