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:inconnect’
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:inmysql_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:inconnection=’
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:inconnection’
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:increate_tables’
from web/script/setup_database:19:in run' from web/script/setup_database:9:inrun’
from web/script/setup_database:297
I know this is a total noob issue, but any help would be greatly
appreciated.