Database support: MySQL

Opening a connection

Connecting to Localhost

When opening a connection to a MySQL server running on your local computer, entering localhost in the host name field will result in the use of the Unix socket, which defaults to /tmp/mysql.sock. If this attempt fails, MacSQL will attempt to use an alternate socket.

By default, that alternate socket is /tmp/lassomysql.sock, the default value used by the version of MySQL included with Lasso from BlueWorld Communications. You can override this value by entering the following at the terminal (on a single line):

defaults write com.rtlabs.MacSQL.MySQLPlugin MySQLLocalSocket /path/to/socket

Only Using a Single Database

If you only need to work with one database on the server (for example, if you are connecting to a MySQL server that hosts databases for hundreds or thousands of users), enter that database name in the Database field when opening the new connection.

Once your connection is opened and a document is created, you can change what databases are loaded at startup in the Settings panel.