Rails - Feb 2008 - Slightly OT, Issue with mysql 5.0 and root password

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
-~----------~----~----~----~------~----~------~--~---

> 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
-~----------~----~----~----~------~----~------~--~---

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
-~----------~----~----~----~------~----~------~--~---