in continuation to my earlier mail, if i entered the command> mysql -u root -p depot_development <db/create.sqlinstead of> mysql depot_development <db/create.sqlthen it works. can anyone please enlighten me on whats happening? mysql is configured with a blank password for root@localhost. thank you, -- Prithvi Krishna Mandava (91)9880067859 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
See my post about using sudo - this is essentialy the same thing.. You are running the command as the root user on your machine. On 12/22/06, Prithvi Krishna Mandava <mandavaprithvi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> in continuation to my earlier mail, > > if i entered the command > > mysql -u root -p depot_development <db/create.sql > > instead of > > mysql depot_development <db/create.sql > > > then it works. can anyone please enlighten me on whats happening? > mysql is configured with a blank password for root@localhost. > > thank you, > > > -- > Prithvi Krishna Mandava > (91)9880067859 > > >--~--~---------~--~----~------------~-------~--~----~ 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 Dec 22, 2006, at 9:10 AM, toby privett wrote:> See my post about using sudo - this is essentialy the same thing.. > > You are running the command as the root user on your machine. > > On 12/22/06, Prithvi Krishna Mandava <mandavaprithvi-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> in continuation to my earlier mail, >> >> if i entered the command >> > mysql -u root -p depot_development <db/create.sql >> >> instead of >> > mysql depot_development <db/create.sql >> >> >> then it works. can anyone please enlighten me on whats happening? >> mysql is configured with a blank password for root@localhost. >> >> thank you, >> >> >> -- >> Prithvi Krishna Mandava >> (91)9880067859 >> >No, sudo runs a command as the user ''root'' on the operating system (assuming Unix-like) The user named ''root'' for MySQL is all-powerful, but only within the database, not the entire system. I suspect that you''re logged in as a user named ''ODBC'' or perhaps there is an environment variable that mysql picks up as the user (try: env | grep -e ODBC ). Doing the initial creation of the database (i.e., depot_development) is often done as the "mysql -u root" user, but then you typically also create a user to be used for that database (doesn''t have to be exclusive) and the tables within that database are created by the non-root user. -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@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 -~----------~----~----~----~------~----~------~--~---
I created the databases and tables from root like this: depot> mysql -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. mysql> create database depot_development; mysql> create database depot_test; mysql> create database depot_production; mysql> grant all on depot_development.* to ''dave''@''localhost''; mysql> grant all on depot_test.* to ''dave''@''localhost''; mysql> grant all on depot_production.* to ''prod''@''localhost'' identified by ''wibble''; mysql> exit and then editing database.yml to remove the username and password from the tables for development and test. --~--~---------~--~----~------------~-------~--~----~ 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 Dec 22, 2006, at 12:45 PM, Mandava wrote:> I created the databases and tables from root like this: > > depot> mysql -u root -p > Enter password: ******* > Welcome to the MySQL monitor. Commands end with ; or \g. > mysql> create database depot_development; > mysql> create database depot_test; > mysql> create database depot_production; > mysql> grant all on depot_development.* to ''dave''@''localhost''; > mysql> grant all on depot_test.* to ''dave''@''localhost''; > mysql> grant all on depot_production.* to ''prod''@''localhost'' > identified > by ''wibble''; > mysql> exit > > and then editing database.yml to remove the username and password from > the tables for development and test.Do you mean that you *changed* the username to "dave" and removed the password? You could then generate your depot_development tables with: mysql -u dave depot_development < db/create.sql (from memory so please forgive any typos) -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@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 -~----------~----~----~----~------~----~------~--~---
its working but i kinda don remember wat exactly i was doing!! i was getting frustrated with the total lack of explanation in the book about the syntax. the authors assume you have expert-level knowledge in everything other than ROR.. and they take it for granted.. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---