I’ve run into a problem on my Mac PowerBook G4 related to MySQL access.
Everything works fine for migrations and script/server (read and write
to the development database), but get the following error with ‘rake
test’ and ‘script/server’:
Mysql::Error: Access denied for user 'rails'@'localhost' (using
password: YES)
Any ideas on what is causing this?
My database.yml file is:
development:
adapter: mysql
database: st_development
host: localhost
username: rails
password:
test:
adapter: mysql
database: st_test
host: localhost
username: rails
password:
production:
adapter: mysql
database: st_production
host: localhost
username: rails
password: ******
$ gem query -n mysql
*** LOCAL GEMS ***
mysql (2.7)
MySQL/Ruby provides the same functions for Ruby programs that the
MySQL C API provides for C programs.
$ rails -v
Rails 1.1.6
$ ruby -v
ruby 1.8.5 (2006-08-25) [powerpc-darwin8.8.0]
$ mysql --version
mysql Ver 14.7 Distrib 4.1.20, for apple-darwin8.8.0 (powerpc) using
EditLine wrapper
$ uname -a
Darwin larry-wifi.quiconnect.net 8.8.0 Darwin Kernel Version 8.8.0: Fri
Sep 8 17:18:57 PDT 2006; root:xnu-792.12.6.obj~1/RELEASE_PPC Power
Macintosh powerpc