MySQL for Other Applications: Installation
- Introduction
- MySQL for Other Applications
- Working with data
- Installation: Sequel Pro
- If you are using Mac OS X, I strongly recommend the Sequel Pro application. It is a fairly simple and reliable means of connecting to a MySQL database without having to use the command line. We’ll do a little bit of command line work in this tutorial in case you need to import or work with data from behind a firewall, but only a little. If at all possible, I recommend using Sequel Pro or a program similar to it, to manage your MySQL databases.
- The Command Line
- If you are not using Sequel Pro, you’ll need to use some other interface to MySQL, or use the command-line “mysql” application that comes with MySQL. With the Mac OS X installation, the mysql install is in /usr/local/mysql. You’ll use the mysql command line by going to the terminal (in your Utilities folder) and typing:
- Installation: MySQL
- We’ll be installing the full MySQL server on your desktop computer. This portion of the tutorial is geared pretty much exclusively to the Macintosh. Installation of MySQL on Mac OS X is quick and easy.
- Turn on your firewall
- Until you need some other computer to be able to access your MySQL database, you should make sure that no one outside your computer can access it. Make sure that your firewall is turned on, and make sure that it is not allowing entry by port 3306. On Mac OS X, this is easy: go to your System Preferences, into the Security preference, start the firewall on the firewall tab, and make sure that the access list does not contain 3306 or MySQL.