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