# Can't connect ot MySQL with YourSQL **URL:** \ **Category:** Rails\ **Created:** [January 31, 2006, 11:36pm UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589 "2006-01-31T23:36:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![sauy7](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sauy7](https://www.ruby-forum.com/u/sauy7)\ **Post date:** [January 31, 2006, 11:36pm UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589/1 "2006-01-31T23:36:23Z")
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 F. ---
**Author:** ![sauy7](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sauy7](https://www.ruby-forum.com/u/sauy7)\ **Post date:** [January 31, 2006, 11:48pm UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589/2 "2006-01-31T23:48:27Z")
Is ur database sever is in same machine? Rgds, –Siva J. [http://www.varcasa.com/](http://www.varcasa.com/) My First Rails Project. Powered by Typo and soon by RForum too ---
**Author:** ![sauy7](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sauy7](https://www.ruby-forum.com/u/sauy7)\ **Post date:** [January 31, 2006, 11:51pm UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589/3 "2006-01-31T23:51:32Z")
On 1/31/06, Siva J. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 F. ---
**Author:** ![sauy7](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sauy7](https://www.ruby-forum.com/u/sauy7)\ **Post date:** [January 31, 2006, 11:54pm UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589/4 "2006-01-31T23:54:33Z")
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 F. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > – > Jim F. > > * * * > > Rails mailing list > removed\_email\_address@domain.invalid > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) – Rgds, –Siva J. [http://www.varcasa.com/](http://www.varcasa.com/) My First Rails Project. Powered by Typo and soon by RForum too ---
**Author:** ![sauy7](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sauy7](https://www.ruby-forum.com/u/sauy7)\ **Post date:** [February 1, 2006, 10:52am UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589/5 "2006-02-01T10:52:43Z")
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. ---
**Author:** ![sauy7](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ecc23a/32.png) [@sauy7](https://www.ruby-forum.com/u/sauy7)\ **Post date:** [February 1, 2006, 12:03am UTC](https://www.ruby-forum.com/t/cant-connect-ot-mysql-with-yoursql/99589/6 "2006-02-01T00:03:37Z")
On 1/31/06, Siva J. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 > removed\_email\_address@domain.invalid > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) – Jim F.