Hello all: I am trying to get started with ROR coming from a classic ASP background. I am going step by step through "Agile Web Development with Rails" isbn 0-9766940-0-x. On page 55 I am trying backup my DDL with the fallowing code: depot> mysql depot_development <db/create.sql ERROR 1045 <28000>: Access denied for user ''ODBC''@''localhost'' (using password: NO) What am I doing wrong. Let me know if you need more info. Thanks for your help -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Ian Seabock wrote:> depot> mysql depot_development <db/create.sql > > ERROR 1045 <28000>: Access denied for user ''ODBC''@''localhost'' (using > password: NO) > > What am I doing wrong. Let me know if you need more infoYou proably need to pass the correct username and password for your install of MySQL and chosen database. Check the doco on the mysql command to findout how to pass them in. Cheers, Anthony Richardson --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 26, 2007, at 8:00 PM, Ian Seabock wrote:> ERROR 1045 <28000>: Access denied for user ''ODBC''@''localhost'' (using > password: NO)This is a MySQL problem. See MySQL''s documentation on what''s going wrong... http://dev.mysql.com/doc/refman/5.0/en/access-denied.html Just from what you''ve provided, I would guess that your installation of MySQL hasn''t been completed. There are steps for securing the initial MySQL account... http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html ...and steps for creating users to access the databases... http://dev.mysql.com/doc/refman/5.0/en/adding-users.html Once I secure the initial account from the command line, I prefer to use PhpMyAdmin to do the rest, like creating databases and assigning privileges... http://www.phpmyadmin.net/ You need to create the database and set its privileges before you can run the migrations on it. Jose ....................................................... Jose Hales-Garcia UCLA Department of Statistics jose-oNoWckAxTcaFhjwBz98joA@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
You can download the free mysql-administrator gui tool from mysql''s site and it greatly simplifies adding users and delegating permissions. Ian Seabock wrote:> Hello all: > > I am trying to get started with ROR coming from a classic ASP > background. > > I am going step by step through "Agile Web Development with Rails" isbn > 0-9766940-0-x. On page 55 I am trying backup my DDL with the fallowing > code: > > depot> mysql depot_development <db/create.sql > > ERROR 1045 <28000>: Access denied for user ''ODBC''@''localhost'' (using > password: NO) > > What am I doing wrong. Let me know if you need more info. > > Thanks for your help >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---