Since upgrading my MacBook to leopard I''ve been experiencing a frustrating issue with MySQL. I installed rb-mysql using macports, which installed mysql 5 as well. The problem is that unlike before I can''t get into mysql as the root user without explicitly providing a root password, even though the root password is empty. Macintosh:test rick$ mysql5 -u root ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: YES) Macintosh:test rick$ mysql5 -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 Server version: 5.0.51 Source distribution Type ''help;'' or ''\h'' for help. Type ''\c'' to clear the buffer. mysql> Since this is a development only machine, I really want to have an empty root mysql password. Before, logging in as root worked with no -p option. This issue seems to be wreaking havoc with my ability to run Rails regression tests. Has anyone seen this and have any insight as to how to get MySQL 5 to work without prompting for a blank password? -- Rick DeNatale My blog on Ruby http://talklikeaduck.denhaven2.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 -~----------~----~----~----~------~----~------~--~---
Rimantas Liubertas
2008-Feb-19 01:22 UTC
Re: Slightly OT, Issue with mysql 5.0 and root password
> The problem is that unlike before I can''t get into mysql as the root > user without explicitly providing a root password, even though the > root password is empty. > > Macintosh:test rick$ mysql5 -u root > ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using > password: YES)<...> Looks like wrong password is provided even if you don''t specify it. Can you check MySQL configuration files, maybe macports installer put options into it? Look for /etc/my.cnf, ~/.my.cnf, $MYSQL_HOME/my.cnf if you see something like: [client] user = root password = sometpass that may be it. Regards, Rimantas -- http://rimantas.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 -~----------~----~----~----~------~----~------~--~---
Rick DeNatale
2008-Feb-19 02:34 UTC
Re: Slightly OT, Issue with mysql 5.0 and root password
On Feb 18, 2008 8:22 PM, Rimantas Liubertas <rimantas-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > The problem is that unlike before I can''t get into mysql as the root > > user without explicitly providing a root password, even though the > > root password is empty. > > > > Macintosh:test rick$ mysql5 -u root > > ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using > > password: YES) > <...> > > Looks like wrong password is provided even if you don''t specify it. > Can you check MySQL configuration files, maybe macports installer put > options into it? Look for /etc/my.cnf, ~/.my.cnf, $MYSQL_HOME/my.cnf > if you see something like: > > [client] > user = root > password = sometpass > > that may be it.Thanks, that was basically it. I figured it out earlier today. -- Rick DeNatale My blog on Ruby http://talklikeaduck.denhaven2.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 -~----------~----~----~----~------~----~------~--~---