CocoaMySQL

Will there be a new version soon? Is CocoaMySQL still developed?

Yes, CocoaMySQL is still developed, but unfortunately I have very few time to work on it. I am working on a new release which I hope to release soon! It will also support MySQL 4.1. Check the beta page to view the progress.

I cannot connect to a MySQL database on a remote server. I always get the error "Unable to connect to host xy. Be sure that the address is correct and that you have the necessary privileges.".

CocoaMySQL v0.5 cannot connect to MySQL > 4.1 because of the new password enryption. If you want to connect to a server running MySQL > 4.1, you have to use one of the following solutions:

• Use the beta version (recommended).
• Look at the website http://dev.mysql.com/doc/mysql/en/old-client.html for using old password encryption with MySQL 4.1.
• Do not set a password for your account (which can be a security problem).

Often remote access to databases is disabled because of security reasons. If you can connect to the database with php scripts on the server, but not with CocoaMySQL, this may be the problem.

• If you are the administrator of the server: Look at the table mysql.user and set the field Host for your user to "%" to enable access from all hosts or add an entry for your user with your hostname in the field Host to enable access from your host only. Be sure to query a "FLUSH PRIVILEGES" after that to reload the grant tables.
  Attention (from the MySQL documentation): A very common error is to insert a new entry with Host='%' and User='some_user', thinking that this allows you to specify localhost to connect from the same machine. The reason that this does not work is that the default privileges include an entry with Host='localhost' and User=''. Because that entry has a Host value 'localhost' that is more specific than '%', it is used in preference to the new entry when connecting from localhost! The correct procedure is to insert a second entry with Host='localhost' and User='some_user', or to delete the entry with Host='localhost' and User=''. After deleting the entry, remember to issue a FLUSH PRIVILEGES statement to reload the grant tables.
• If you have shell access to the server: Use an ssh tunnel. To open an ssh tunnel, type in the Terminal something like: "ssh -L 8888:your.server.com:3306 youruser@your.server.com", then connect with CocoaMySQL using "127.0.0.1" as host, "8888" as port and your normal MySQL user and password.
• Otherwise ask your provider to give you remote access to your database.
• Look at http://dev.mysql.com/doc/refman/5.0/en/access-denied.html for more information about access denied errors.

CocoaMySQL is not working with MySQL 4.1.14. Is there a way to use CocoaMySQL with this version?

Try the the newest beta which you find on https://sourceforge.net/project/showfiles.php?group_id=54999, it should work fine with MySQL 4.1.14.

My server doesn't support backticks ("`") to escape table and column names. Therefore CocoaMySQL doesn't work at all for me.

Download this modified version which is equal to version 0.5 but doesn't use backticks.

I have installed MySQL on my computer, how can I connect to the server using CocoaMySQL?

First, be sure that the server is running (try connecting using the command line utility "mysql"). Then try connecting using CocoaMySQL with "127.0.0.1" or "localhost" as host. If you don't know your username and password, try "root" as username and leave the password field blank (it's a good idea to set the root password afterwards if it works!).

I have downloaded CocoaMySQL and want to use MySQL, but I have no MySQL server to connect to. What should I do?

There are several ways to install MySQL on a Mac:

• Use the official MySQL release: http://dev.mysql.com/downloads/mysql/5.0.html. Go to Marc Liyanage's website for more installation instructions.
• Use MAMP which is a Mac installer for Apache, MySQL and PHP: http://www.mamp.info.
• Use the packages from serverlogistics: http://serverlogistics.com/mysql.php.

Where do I find the universal binary of the SMySQL framework which CocoaMySQL uses?

The changes necessary to build a universal binary of the SMySQL framework have been provided by Kelly Hawk (thanks a lot for that!). You can download the source and the bundled and system build here (the system build isn't tested):

• http://cocoamysql.sourceforge.net/downloads/SMySQL_3.0.1.zip
• http://cocoamysql.sourceforge.net/downloads/MCPKit_bundled.framework.zip
• http://cocoamysql.sourceforge.net/downloads/MCPKit_system.framework.zip