From: John Joyce <dangerwillrobinsondanger@...>
Date: 2007-09-07T02:16:15+09:00
Subject: Re: ruby on rails with mysqladmin


On Sep 6, 2007, at 10:25 AM, a marc aurele wrote:

> Hi all
>
> with :
>     mysqladmin -u root create dummy_development
>
> I get :
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password:  
> NO)'
>
> all i have in terms of firewall is windows and the localhost:3000
> works for sure anyways, i even loaded a page on it.
> And the YML file shows me im ok , i dont need a password etc :
>
> development:
> adapter: mysql
> database: dummy_development
> username: root
> password:
> host: localhost
>
> I tried the same thing at work , no problems with it.
> Any ideas what's going on please  ? thanks
>
>
>
This is really a mysql question, but here goes:
you need to enter this:
mysql -u username -p

then the password.
you don't need to use mysqladmin

You might need to grant all priveledges to root, but you should not  
have to do that.

After you entered the password you will be in a shell-like command  
line environment for mysql.
You can try to do it all in one command line, but it's really a lot  
easier to do it one step at a time.
in the mysql command line tool, enter your sql commands.
A complete command is terminated with a semicolon ;
if you press enter before typing a semicolon, it thinks you are going  
to type more, but you can always put the semicolon on the next line.
to create a database you should use:
create database db_name;
to see all of them:
show databases;

Beyond that, pickup a copy of any good mysql book. The MySQL Phrase  
Book is good, but you might want Learning MySQL.
You don't need to know a lot of it to use it with Rails or Ruby  
(active record) but if you use Ruby DBI you will need to have an SQL  
reference.
You should get a reference book for any database you plan to use.
The SQL Cookbook is a good choice as well. It will give you solutions  
for many different db's!