# MailSteward Pro™

Contents: Home Installing MySQL© Connect to MySQL© Server Federal Legal Requirements Settings Archive Email Search Email Indexing for faster searches Browse Email Schedule Archive Tags Back Up Your Database Export... Import mbox files... Import MailSteward SQL file Check for Duplicate Email Database Statistics Report... System Requirements Links: MailSteward Request a feature Submit a Bug MySQL© MailTags© Sequel Pro CronniX | 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. Normally you will connect as the MySQL 'root' user, but if you have created other MySQL users, you can use them instead. If you have not assigned a password to the root user, leave the password box blank. 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. If MailSteward Pro is being launched for the first time, and no database is specified, a default database named 'myemaildb' will be created. 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.

TM & Copyright © 2004-2009 pubblog.com. All rights reserved.
MySQL is Copyright © 1995-2009 MySQL AB. All rights reserved.
MailTags is Copyright © Scott Morrison.