Unable to connect to mySql localhost


#1

Unable to connect to mySql localhost

I installed MySQL 5.0 community version, without opening an account and
leaving the password empty with the Path included in the environment
variable.

In the post-installation testing, I typed C:\mysqlshow, the error
message is
Mysqlshow: Access denied for user â??ODBCâ??@â??localhostâ??

Next, in RadRails 0.6.3, when I double-clicked on the Development
database trying to browse the database, the error message is â??Unable to
connect to database, see log for more info�

What did I do wrong?

The other info are as follows:

OS: Windows XP Pro
Database Server: MySQL 5.0
Ruby: 184_17
Rails: 1.1.2 (Generated from Gem)
RadRails: 0.6.3
SQL-Front

Would appreciate it if someone could help out.


#2

Your database.yml is not configured properly. If you have a user
called root with no password, use that information in the
database.yml.

~ Ben

On 5/17/06, Ling removed_email_address@domain.invalid wrote:

Ruby: 184_17


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails


Ben R.
303-947-0446
http://www.benr75.com


#3

That is what is inside the database.yml.

development:
adapter: mysql
database: cookbook2
username: root
password:
host: localhost

What else could have been wrong?

Ling.

Ben R. wrote:

Your database.yml is not configured properly. If you have a user
called root with no password, use that information in the
database.yml.

~ Ben

On 5/17/06, Ling removed_email_address@domain.invalid wrote:

Ruby: 184_17


Rails mailing list
removed_email_address@domain.invalid
http://lists.rubyonrails.org/mailman/listinfo/rails


Ben R.
303-947-0446
http://www.benr75.com


#4

What error message are you getting?
Cheers


#5

Pat L. wrote:

What error message are you getting?
Cheers

In the post-installation testing, I typed C:>mysqlshow
The error message is

Mysqlshow: Access denied for user â??ODBCâ??@â??localhostâ??

Next, in RadRails 0.6.3, when I double-clicked on the Development
database trying to browse the database, the error message is

â??Unable to connect to database, see log for more infoâ?

Besides, the “tree” in the Data Navigator of the RadRails didn’t appear
at all.

Regards

Ling