ruby on rails with mysqladmin

[a marc aurele]

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

 

[John Joyce]

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!

 

[JeremyWoertink]

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

 

[John Joyce]

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

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