MailSteward Pro™

Contents:

Connect to MySQL© Server:

When MailSteward Pro is launched, before archiving, searching, or browsing can be done, a connection to a MySQL server must be established.

To connect to a server, fill in the host, user, and password, and click on the Connect button. You can also specify a socket and port if necessary. If no socket is entered, the default is assumed to be at /tmp/mysql.sock. If you are running the Mac OS X Server system, which has MySQL already installed, the standard location for the socket will be /var/mysql/mysql.sock.

Specifying a particular database is optional. You can do that later in the Settings window. If no database is specified, the database which is set in Settings will be used. A connection name can be given to the connection and the connection information can be saved by clicking on the Save button. Saved connections can be deleted by clicking on the Delete button.

If you are running the MySQL server on an OS X Server machine, and wish to connect to it from anywhere on your local area network, you will need to grant privileges to everyone on the LAN. You can do this with the 'mysql' utility. First type the following on the command line in a terminal window:

mysql -u root -p

Enter your password when prompted and then enter the following (all on one line):

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.1.%'
IDENTIFIED BY "password" WITH GRANT OPTION

You will need to substitute the appropriate IP address and password. The "%" is a wildcard which is used to allow connection from any host on the LAN. Your local IP addresses may be different. For example they might all begin with "192.168.0." rather than "10.0.1.".

Your connection to the MySQL server will then look something like this:

You will find the hostname of your OS X Server by clicking on Sharing in System Preferences on the server.