# Regarding jake's Article on getting radiant up and running o

**URL:** <https://www.ruby-forum.com/t/regarding-jakes-article-on-getting-radiant-up-and-running-o/66819>\
**Category:** Radiant CMS\
**Created:** [August 29, 2006, 4:19pm UTC](https://www.ruby-forum.com/t/regarding-jakes-article-on-getting-radiant-up-and-running-o/66819 "2006-08-29T16:19:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike\_Moscow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/f6c823/32.png) [@Mike\_Moscow](https://www.ruby-forum.com/u/Mike_Moscow)\
**Post date:** [August 29, 2006, 4:19pm UTC](https://www.ruby-forum.com/t/regarding-jakes-article-on-getting-radiant-up-and-running-o/66819/1 "2006-08-29T16:19:23Z")

</div>

Jake’s guide is clear enough but I seem to have problems connecting to  
the database. I’m on a mac (10.4.7) I have figured out how to SSh  
directly into my shared account using the BASH terminal.

I get as far as installing radiant with svn, But I keep running into  
issues  
with the databases. I reallize that this might be a common issue but i  
couldnt find a solution in the archives or elsewhere.

I tried to create the databases via SSH using the mysql commands, I’m  
able to log into mysql but everytime I try to create a database I get  
the following error:  
mysql\> create database USERNAME\_radiant\_live;  
ERROR 1044 (42000): Access denied for user ‘USERNAME’@‘localhost’ to  
database ‘Username\_radiant\_live’

If I create my databases via webmin, reference them from  
config/database.yml and run script/setup\_database production it almost  
overwrites the existing databases. But then it fails:

[USERNAME@howe ~]$ web/script/setup\_database production  
Run `setup_database --help` for information on additional options.

Loading production environment…OK

WARNING! This script will overwrite information currently stored in the  
database “radiant\_live”. Are you sure you want to continue? [Yn] y

Creating tables…  
– drop\_table(“config”)  
– create\_table(“config”, {:force=\>true})  
FAILED  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:330:in  
`real_connect': Access denied for user 'root'@'localhost' (using password: NO) (Mysql::Error) from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:330:in`connect’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:87:in  
`initialize' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:36:in`mysql\_connection’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:251:in  
`connection_without_query_cache=' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/query_cache.rb:54:in`connection=’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/connection\_specification.rb:220:in  
`retrieve_connection' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:78:in`connection’  
from  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/migration.rb:273:in  
`method_missing' ... 8 levels... from web/script/setup_database:99:in`create\_tables’  
from web/script/setup\_database:19:in `run' from web/script/setup_database:9:in`run’  
from web/script/setup\_database:297

I know this is a total noob issue, but any help would be greatly  
appreciated.

---

<div class="post-metadata">

**Author:** ![Mike\_Moscow](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/f6c823/32.png) [@Mike\_Moscow](https://www.ruby-forum.com/u/Mike_Moscow)\
**Post date:** [August 29, 2006, 4:41pm UTC](https://www.ruby-forum.com/t/regarding-jakes-article-on-getting-radiant-up-and-running-o/66819/2 "2006-08-29T16:41:25Z")

</div>

Mike Moscow wrote:

> Creating tables…  
> – drop\_table(“config”)  
> – create\_table(“config”, {:force=\>true})  
> FAILED  
> /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:330:in  
> `real\_connect’: Access denied for user ‘root’@‘localhost’ (using  
> password: NO) (Mysql::Error)

You must specify the correct username and password in  
config/database.yml. Right now you have it set to the defaults:

username: root  
password:

–  
John L.  
[http://wiseheartdesign.com](http://wiseheartdesign.com)