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
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060131/3c555f11/attachment.html
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
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:> > 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 > _______________________________________________ > 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060131/e0336f29/attachment.html
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 configI 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.> On 1/31/06, Jim Freeze <rails@freeze.org> wrote: > > > > 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. > > > > > > -- > > Rgds, > --Siva Jagadeesan > http://www.varcasa.com/ > My First Rails Project. Powered by Typo and soon by RForum too > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-- Jim Freeze
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. On 31 Jan 2006, at 23:01, Jim Freeze wrote:> 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.-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060201/1e5451ba/attachment.html