Hello, I am having problems with MySQL. Running: PC with Windows Vista Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) I have edited the database.yml file. I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root And it says "password:". I press enter and it shoots this error. " mysqladmin: Unknown command: ''root'' " Any ideas? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Hi, Remove the space between the -p and root ie mysqladmin -u root -proot Simon On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Hello, > > I am having problems with MySQL. > > Running: PC with Windows Vista > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > I have edited the database.yml file. > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > And it says "password:". > > I press enter and it shoots this error. > > " mysqladmin: Unknown command: ''root'' " > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Nothing. It just gives me the help list. On Nov 24, 12:31 am, "Simon Macneall" <macne...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, > > Remove the space between the -p and root > > ie mysqladmin -u root -proot > > Simon > > On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > > > Hello, > > > I am having problems with MySQL. > > > Running: PC with Windows Vista > > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > > I have edited the database.yml file. > > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > > And it says "password:". > > > I press enter and it shoots this error. > > > " mysqladmin: Unknown command: ''root'' " > > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Are you trying to log into the mysql command line tool to do sql queries etc? if so, then it isn''t mysqladmin, it is just mysql ie ''mysql -u root -proot'' if you are actually trying to do something with mysqladmin, you need to put that command on the command line, ie ''mysqladmin -u root -proot ping'' On Mon, 24 Nov 2008 15:37:01 +0900, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Nothing. It just gives me the help list. >--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
the command "mysql -u root" worked for me. Thanks, On Nov 24, 12:37 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Nothing. It just gives me the help list. > > On Nov 24, 12:31 am, "Simon Macneall" <macne...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hi, > > > Remove the space between the -p and root > > > ie mysqladmin -u root -proot > > > Simon > > > On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > wrote: > > > > Hello, > > > > I am having problems with MySQL. > > > > Running: PC with Windows Vista > > > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > > > I have edited the database.yml file. > > > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > > > And it says "password:". > > > > I press enter and it shoots this error. > > > > " mysqladmin: Unknown command: ''root'' " > > > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
It will let me go into mysql but I want to create a database. It is not letting me. It says install gem mysql... I did that and got an error. It reads "While generating documentation for mysql... MESSAGE: Unhandled special: Special: type=17..." etc On Nov 24, 12:45 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> the command "mysql -u root" worked for me. > > Thanks, > > On Nov 24, 12:37 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Nothing. It just gives me the help list. > > > On Nov 24, 12:31 am, "Simon Macneall" <macne...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Hi, > > > > Remove the space between the -p and root > > > > ie mysqladmin -u root -proot > > > > Simon > > > > On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > > > wrote: > > > > > Hello, > > > > > I am having problems with MySQL. > > > > > Running: PC with Windows Vista > > > > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > > > > I have edited the database.yml file. > > > > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > > > > And it says "password:". > > > > > I press enter and it shoots this error. > > > > > " mysqladmin: Unknown command: ''root'' " > > > > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I try the command "rake db:migrate" and it tells me it cannot find libmysql.dll file. On Nov 24, 1:02 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> It will let me go into mysql but I want to create a database. It is > not letting me. It says install gem mysql... I did that and got an > error. It reads "While generating documentation for mysql... MESSAGE: > Unhandled special: Special: type=17..." etc > > On Nov 24, 12:45 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > the command "mysql -u root" worked for me. > > > Thanks, > > > On Nov 24, 12:37 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Nothing. It just gives me the help list. > > > > On Nov 24, 12:31 am, "Simon Macneall" <macne...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi, > > > > > Remove the space between the -p and root > > > > > ie mysqladmin -u root -proot > > > > > Simon > > > > > On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphett...@gmail.com> > > > > wrote: > > > > > > Hello, > > > > > > I am having problems with MySQL. > > > > > > Running: PC with Windows Vista > > > > > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > > > > > I have edited the database.yml file. > > > > > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > > > > > And it says "password:". > > > > > > I press enter and it shoots this error. > > > > > > " mysqladmin: Unknown command: ''root'' " > > > > > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
You have to have your mysql bin directory in your PATH environment variable. So if you installed mysql in c:\mysql then add c:\mysql\bin to your path. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
"Elementary, my dear Watson" :-) Copy the dll to c:\windows or add it to your path. - http://forums.mysql.com/read.php?52,37151,192816 - http://hillemania.wordpress.com/2006/09/21/rails-mysql-50-on-windows-setup-problemfix-libmysqldll/ Also, Google is much better than Sherlock Holmes... Cheers, Sazima On Nov 24, 5:28 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I try the command "rake db:migrate" and it tells me it cannot find > libmysql.dll file. > > On Nov 24, 1:02 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > It will let me go into mysql but I want to create a database. It is > > not letting me. It says install gem mysql... I did that and got an > > error. It reads "While generating documentation for mysql... MESSAGE: > > Unhandled special: Special: type=17..." etc > > > On Nov 24, 12:45 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > the command "mysql -u root" worked for me. > > > > Thanks, > > > > On Nov 24, 12:37 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Nothing. It just gives me the help list. > > > > > On Nov 24, 12:31 am, "Simon Macneall" <macne...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > Hi, > > > > > > Remove the space between the -p and root > > > > > > ie mysqladmin -u root -proot > > > > > > Simon > > > > > > On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphett...@gmail.com> > > > > > wrote: > > > > > > > Hello, > > > > > > > I am having problems with MySQL. > > > > > > > Running: PC with Windows Vista > > > > > > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > > > > > > I have edited the database.yml file. > > > > > > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > > > > > > And it says "password:". > > > > > > > I press enter and it shoots this error. > > > > > > > " mysqladmin: Unknown command: ''root'' " > > > > > > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I did that and it worked. But I type in the "rake db:migrate" command and it tells me " Access denied for user ''root@localhost'' " On Nov 24, 7:36 am, Sazima <rsaz...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> "Elementary, my dear Watson" :-) > > Copy the dll to c:\windows or add it to your path. > > -http://forums.mysql.com/read.php?52,37151,192816 > -http://hillemania.wordpress.com/2006/09/21/rails-mysql-50-on-windows-... > > Also, Google is much better than Sherlock Holmes... > > Cheers, Sazima > > On Nov 24, 5:28 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > I try the command "rake db:migrate" and it tells me it cannot find > > libmysql.dll file. > > > On Nov 24, 1:02 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > It will let me go into mysql but I want to create a database. It is > > > not letting me. It says install gem mysql... I did that and got an > > > error. It reads "While generating documentation for mysql... MESSAGE: > > > Unhandled special: Special: type=17..." etc > > > > On Nov 24, 12:45 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > the command "mysql -u root" worked for me. > > > > > Thanks, > > > > > On Nov 24, 12:37 am, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > Nothing. It just gives me the help list. > > > > > > On Nov 24, 12:31 am, "Simon Macneall" <macne...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > > Hi, > > > > > > > Remove the space between the -p and root > > > > > > > ie mysqladmin -u root -proot > > > > > > > Simon > > > > > > > On Mon, 24 Nov 2008 15:27:07 +0900, Mr. Watson <graphett...@gmail.com> > > > > > > wrote: > > > > > > > > Hello, > > > > > > > > I am having problems with MySQL. > > > > > > > > Running: PC with Windows Vista > > > > > > > Installed: Instant Rails AND RoR on (http://www.rubyonrails.com) > > > > > > > > I have edited the database.yml file. > > > > > > > > I went to C:/InstantRails/mysql/bin>mysqladmin -u root -p root > > > > > > > > And it says "password:". > > > > > > > > I press enter and it shoots this error. > > > > > > > > " mysqladmin: Unknown command: ''root'' " > > > > > > > > Any ideas?--~--~---------~--~----~------------~-------~--~----~ 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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mon, Nov 24, 2008 at 8:25 AM, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > I did that and it worked. But I type in the "rake db:migrate" command > and it tells me " Access denied for user ''root@localhost'' "You need to configure config/database.yml with the appropriate access information (username, password, etc.) for your DB. -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@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 -~----------~----~----~----~------~----~------~--~---
Everything is working correct. I can log into MySQL. Ruby on Rails is up on running on the localhost. It created the database for me. But every time I use the rake db:migrate command it gives me the error. "rake aborted! Access denied for user ''root''@''localhost'' (using password: YES) (See full trace by running task with --trace) I ran it with trace and got the following message: "** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted!" (And many system files afterwards) Any ideas? On Nov 24, 11:13 am, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 24, 2008 at 8:25 AM,Mr.Watson<graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > I did that and it worked. But I type in the "rake db:migrate" command > > and it tells me " Access denied for user ''root@localhost'' " > > You need to configure config/database.yml with the appropriate > access information (username, password, etc.) for your DB. > > -- > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
It is acting like it is working. For example, I typed in rake db:migrate and it created the databse and the post.rb file. But it is still showing the error: "Access denied for user ''root''@''localhost'' (using password: YES)" On Nov 24, 2:20 pm, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Everything is working correct. I can log into MySQL. Ruby on Rails is > up on running on the localhost. It created the database for me. But > every time I use the rake db:migrate command it gives me the error. > > "rake aborted! > Access denied for user ''root''@''localhost'' (using password: YES) > > (See full trace by running task with --trace) > > I ran it with trace and got the following message: > "** Invoke db:migrate (first_time) > ** Invoke environment (first_time) > ** Execute environment > ** Execute db:migrate > rake aborted!" > > (And many system files afterwards) > > Any ideas? > > On Nov 24, 11:13 am, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > On Mon, Nov 24, 2008 at 8:25 AM,Mr.Watson<graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > I did that and it worked. But I type in the "rake db:migrate" command > > > and it tells me " Access denied for user ''root@localhost'' " > > > You need to configure config/database.yml with the appropriate > > access information (username, password, etc.) for your DB. > > > -- > > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mon, Nov 24, 2008 at 12:20 PM, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Everything is working correct. I can log into MySQL. Ruby on Rails is > up on running on the localhost. It created the database for me. But > every time I use the rake db:migrate command it gives me the error. > > "rake aborted! > Access denied for user ''root''@''localhost'' (using password: YES)That''s saying that the password for root in database.yml is wrong; are you saying that it''s not? You can log in *using the exact same information* as you''ve got in database.yml? -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@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 -~----------~----~----~----~------~----~------~--~---
Also, in SQL, I type "mysql -u root -p=password (as I configured the database.yml file) and it gives me the same error. ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: YES) On Nov 24, 2:20 pm, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Everything is working correct. I can log into MySQL. Ruby on Rails is > up on running on the localhost. It created the database for me. But > every time I use the rake db:migrate command it gives me the error. > > "rake aborted! > Access denied for user ''root''@''localhost'' (using password: YES) > > (See full trace by running task with --trace) > > I ran it with trace and got the following message: > "** Invoke db:migrate (first_time) > ** Invoke environment (first_time) > ** Execute environment > ** Execute db:migrate > rake aborted!" > > (And many system files afterwards) > > Any ideas? > > On Nov 24, 11:13 am, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > On Mon, Nov 24, 2008 at 8:25 AM,Mr.Watson<graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > I did that and it worked. But I type in the "rake db:migrate" command > > > and it tells me " Access denied for user ''root@localhost'' " > > > You need to configure config/database.yml with the appropriate > > access information (username, password, etc.) for your DB. > > > -- > > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mon, Nov 24, 2008 at 12:37 PM, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Also, in SQL, I type "mysql -u root -p=password (as I configured the > database.yml file) and it gives me the same error.That should be -ppassword -- no "=", and no space separating the -p from the actual password. -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@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 -~----------~----~----~----~------~----~------~--~---
Database.yml file: # SQLite version 3.x # gem install sqlite3-ruby (not necessary on OS X Leopard) development: adapter: mysql database: depot_development username: root password: root host: localhost # Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test: adapter: mysql database: depot_test username: root password: root host: localhost production: adapter: mysql database: depot_production username: root password: root host: localhost" I am typing in mysql -u root -p=root On Nov 24, 2:35 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 24, 2008 at 12:20 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Everything is working correct. I can log into MySQL. Ruby on Rails is > > up on running on the localhost. It created the database for me. But > > every time I use the rake db:migrate command it gives me the error. > > > "rake aborted! > > Access denied for user ''root''@''localhost'' (using password: YES) > > That''s saying that the password for root in database.yml is wrong; > are you saying that it''s not? You can log in *using the exact same > information* as you''ve got in database.yml? > > -- > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On the end, I put the " there. It is not in the yml file. On Nov 24, 2:41 pm, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Database.yml file: > > # SQLite version 3.x > # gem install sqlite3-ruby (not necessary on OS X Leopard) > development: > adapter: mysql > database: depot_development > username: root > password: root > host: localhost > > # Warning: The database defined as "test" will be erased and > # re-generated from your development database when you run "rake". > # Do not set this db to the same as development or production. > test: > adapter: mysql > database: depot_test > username: root > password: root > host: localhost > > production: > adapter: mysql > database: depot_production > username: root > password: root > host: localhost" > > I am typing in mysql -u root -p=root > > On Nov 24, 2:35 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > On Mon, Nov 24, 2008 at 12:20 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Everything is working correct. I can log into MySQL. Ruby on Rails is > > > up on running on the localhost. It created the database for me. But > > > every time I use the rake db:migrate command it gives me the error. > > > > "rake aborted! > > > Access denied for user ''root''@''localhost'' (using password: YES) > > > That''s saying that the password for root in database.yml is wrong; > > are you saying that it''s not? You can log in *using the exact same > > information* as you''ve got in database.yml? > > > -- > > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I can log in with mysql -u root but it still gives me an error when using rake db:migrate On Nov 24, 2:35 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 24, 2008 at 12:20 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Everything is working correct. I can log into MySQL. Ruby on Rails is > > up on running on the localhost. It created the database for me. But > > every time I use the rake db:migrate command it gives me the error. > > > "rake aborted! > > Access denied for user ''root''@''localhost'' (using password: YES) > > That''s saying that the password for root in database.yml is wrong; > are you saying that it''s not? You can log in *using the exact same > information* as you''ve got in database.yml? > > -- > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
It still doesn''t work typing "mysql -u root -proot" On Nov 24, 2:46 pm, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I can log in with mysql -u root but it still gives me an error when > using rake db:migrate > > On Nov 24, 2:35 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > On Mon, Nov 24, 2008 at 12:20 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Everything is working correct. I can log into MySQL. Ruby on Rails is > > > up on running on the localhost. It created the database for me. But > > > every time I use the rake db:migrate command it gives me the error. > > > > "rake aborted! > > > Access denied for user ''root''@''localhost'' (using password: YES) > > > That''s saying that the password for root in database.yml is wrong; > > are you saying that it''s not? You can log in *using the exact same > > information* as you''ve got in database.yml? > > > -- > > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Mon, Nov 24, 2008 at 12:48 PM, Mr. Watson <graphettion-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > It still doesn''t work typing "mysql -u root -proot"Then your database.yml is *WRONG*. If you can login to MySQL with only `mysql -u root` it means you have *NO* password set for the root account. Which is bad. You should fix that ASAP and then correct your database.yml. -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@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 -~----------~----~----~----~------~----~------~--~---
It still doesn''t work typing "mysql -u root -proot" On Nov 24, 2:40 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 24, 2008 at 12:37 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Also, in SQL, I type "mysql -u root -p=password (as I configured the > > database.yml file) and it gives me the same error. > > That should be -ppassword -- no "=", and no space separating the -p > from the actual password. > > -- > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I got a password now. (I downloaded MySQL 6.0 to get it) The rake db:migrate command is still not working. On Nov 24, 2:40 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 24, 2008 at 12:37 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Also, in SQL, I type "mysql -u root -p=password (as I configured the > > database.yml file) and it gives me the same error. > > That should be -ppassword -- no "=", and no space separating the -p > from the actual password. > > -- > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
It works. You were right. I made a mistake on the yml. On Nov 24, 2:50 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Mon, Nov 24, 2008 at 12:48 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > It still doesn''t work typing "mysql -u root -proot" > > Then your database.yml is *WRONG*. > > If you can login to MySQL with only `mysql -u root` it means you have > *NO* password set for the root account. Which is bad. You should fix > that ASAP and then correct your database.yml. > > -- > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
It works. You were right. I made a mistake on the yml. On Nov 24, 3:10 pm, "Mr. Watson" <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I got a password now. (I downloaded MySQL 6.0 to get it) The rake > db:migrate command is still not working. > > On Nov 24, 2:40 pm, "Hassan Schroeder" <hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> > wrote: > > > On Mon, Nov 24, 2008 at 12:37 PM, Mr. Watson <graphett...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Also, in SQL, I type "mysql -u root -p=password (as I configured the > > > database.yml file) and it gives me the same error. > > > That should be -ppassword -- no "=", and no space separating the -p > > from the actual password. > > > -- > > Hassan Schroeder ------------------------ hassan.schroe...-Re5JQEeQqe8AvxtiuMwx3w@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@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---