# Ruby on rails with mysqladmin

**URL:** <https://www.ruby-forum.com/t/ruby-on-rails-with-mysqladmin/113955>\
**Category:** Ruby\
**Created:** [September 6, 2007, 5:30pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-with-mysqladmin/113955 "2007-09-06T17:30:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![a\_marc\_aurele](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7993a0/32.png) [@a\_marc\_aurele](https://www.ruby-forum.com/u/a_marc_aurele)\
**Post date:** [September 6, 2007, 5:30pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-with-mysqladmin/113955/1 "2007-09-06T17:30:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![a\_marc\_aurele](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7993a0/32.png) [@a\_marc\_aurele](https://www.ruby-forum.com/u/a_marc_aurele)\
**Post date:** [September 6, 2007, 7:16pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-with-mysqladmin/113955/2 "2007-09-06T19:16:46Z")

</div>

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

> all i have in terms of firewall is windows and the localhost:3000  
> 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!

---

<div class="post-metadata">

**Author:** ![a\_marc\_aurele](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7993a0/32.png) [@a\_marc\_aurele](https://www.ruby-forum.com/u/a_marc_aurele)\
**Post date:** [September 6, 2007, 7:30pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-with-mysqladmin/113955/3 "2007-09-06T19:30:47Z")

</div>

Have you checked your task manager to see if the mysql service is  
running? Can you get into mysql with just: mysql -u root and then  
create it through there? Did you restart your computer? Have you tried  
uninstalling and reinstalling mysql?

if yes to all of these, then I have no clue hopefully someone else  
does.

~Jeremy

---

<div class="post-metadata">

**Author:** ![a\_marc\_aurele](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/7993a0/32.png) [@a\_marc\_aurele](https://www.ruby-forum.com/u/a_marc_aurele)\
**Post date:** [September 6, 2007, 7:49pm UTC](https://www.ruby-forum.com/t/ruby-on-rails-with-mysqladmin/113955/4 "2007-09-06T19:49:52Z")

</div>

On Sep 6, 2007, at 12:30 PM, removed\_email\_address@domain.invalid wrote:

> On Sep 6, 8:25 am, “a marc aurele” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> >

Ah, yes, that is the other thing, you need to make sure the mysql  
server application is running!  
You can configure it to startup when your system starts up.  
You might also consider exploring the GUI apps that now come packaged  
with mysql. they can be pretty useful for beginners with mysql