Forum: Ruby on Rails Unable to connect to mySql localhost

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
24add7ecc1268f49e608dee63413f261?d=identicon&s=25 Ling (Guest)
on 2006-05-17 15:48
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â?? <using password:
NO>

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.
D90ef6808433e63203e15a5c2dadb0bb?d=identicon&s=25 Ben Reubenstein (Guest)
on 2006-05-17 17:18
(Received via mailing list)
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 <l_w_ling@fastmail.fm> wrote:
>
> Ruby:                   184_17
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>


--
Ben Reubenstein
303-947-0446
http://www.benr75.com
24add7ecc1268f49e608dee63413f261?d=identicon&s=25 Ling (Guest)
on 2006-05-17 18:09
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 Reubenstein 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 <l_w_ling@fastmail.fm> wrote:
>>
>> Ruby:                   184_17
>> _______________________________________________
>> Rails mailing list
>> Rails@lists.rubyonrails.org
>> http://lists.rubyonrails.org/mailman/listinfo/rails
>>
>
>
> --
> Ben Reubenstein
> 303-947-0446
> http://www.benr75.com
024e4717cdf03bb03179a9594805431d?d=identicon&s=25 Pat Lynch (Guest)
on 2006-05-18 02:12
(Received via mailing list)
What error message are you getting?
Cheers
24add7ecc1268f49e608dee63413f261?d=identicon&s=25 Ling (Guest)
on 2006-05-18 09:46
Pat Lynch 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â?? <using password:
NO>

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
This topic is locked and can not be replied to.