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. -- Posted via http://www.ruby-forum.com/.
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:> 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. > > > > -- > Posted via http://www.ruby-forum.com/. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- Ben Reubenstein 303-947-0446 http://www.benr75.com
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-- Posted via http://www.ruby-forum.com/.
What error message are you getting? Cheers -----Original Message----- From: rails-bounces@lists.rubyonrails.org [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Ling Sent: Wednesday, May 17, 2006 12:09 PM To: rails@lists.rubyonrails.org Subject: [Rails] Re: Unable to connect to mySql localhost 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-- Posted via http://www.ruby-forum.com/. _______________________________________________ Rails mailing list Rails@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails
Pat Lynch wrote:> What error message are you getting? > CheersIn 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 -- Posted via http://www.ruby-forum.com/.