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:
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
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!