Forum: Ruby on Rails Can't connect ot MySQL with YourSQL

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
54a6b9398d00029e77136b852e32a1bf?d=identicon&s=25 Jim Freeze (Guest)
on 2006-01-31 23:36
(Received via mailing list)
Ok, this seems silly, but I can't connect to mysql from yoursql.
I think I have all the privileges set. I can definitly connect via
the command line, but not via yoursql.

Any hints?

mysql> show grants for 'root'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost
                                                                  |
+-----------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY
PASSWORD '*6C69D17939B2C1D04E17A96F9B29B284832979B7' WITH GRANT OPTION
|
+------------------------------------------------------------------------------------------------------------------------------+

YourSQL - 1.8.0e
MySQL - mysql-standard-5.0.18-osx10.4-powerpc

Thanks

--
Jim Freeze
33bb150cf13d87bce4e80569ca317647?d=identicon&s=25 Siva Jagadeesan (Guest)
on 2006-01-31 23:48
(Received via mailing list)
Is ur database sever is in same machine?

Rgds,
--Siva Jagadeesan
http://www.varcasa.com/
My First Rails Project. Powered by Typo and soon by RForum too
54a6b9398d00029e77136b852e32a1bf?d=identicon&s=25 Jim Freeze (Guest)
on 2006-01-31 23:51
(Received via mailing list)
On 1/31/06, Siva Jagadeesan <sivajagdev@gmail.com> wrote:
> Is ur database sever is in same machine?

Yes. All same machine - OS X 10.4. The YourSQL docs say
that it connects via TCP, even when on localhost. I am assuming
that my grant tables permit my machine to connect, but I am
probably wrong here. Problem is, if something needs to change,
I'm not sure what that is yet.

--
Jim Freeze
33bb150cf13d87bce4e80569ca317647?d=identicon&s=25 Siva Jagadeesan (Guest)
on 2006-01-31 23:54
(Received via mailing list)
could u try to connect using command prompt

mysql -u root -p

If this works then it must be something to do with yoursql config


On 1/31/06, Jim Freeze <rails@freeze.org> wrote:
> --
> Jim Freeze
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>



--

Rgds,
--Siva Jagadeesan
http://www.varcasa.com/
My First Rails Project. Powered by Typo and soon by RForum too
54a6b9398d00029e77136b852e32a1bf?d=identicon&s=25 Jim Freeze (Guest)
on 2006-02-01 00:03
(Received via mailing list)
On 1/31/06, Siva Jagadeesan <sivajagdev@gmail.com> wrote:
> could u try to connect using command prompt
>
> mysql -u root -p
>
> If this works then it must be something to do with yoursql config

I connect just fine from the command line. There are only two
preferences with YourSQL and username/pass are the same as
from the commandine. It may be YourSQL, but I think it is the
privileges table.

> >
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
>


--
Jim Freeze
B4a3fe24e9fb82df573ae5b38aa3b872?d=identicon&s=25 Derek Chesterfield (Guest)
on 2006-02-01 10:52
(Received via mailing list)
Could it be the new style password hashes? If you are using the new-
style hashes, e.g. in MySQL v5, and YourSQL hasn't been updated for
them, then that could be the problem. I know I have to use a
particular version of CocoaMySQL to be able to connect because of the
new hashes.
This topic is locked and can not be replied to.