The MySQL database server is one of the most popular open source databases in the world. Although there is not yet an official package for installing it on the latest version of the Macintosh operating system (Mac OS X 10.7, codenamed Lion), it is possible to install the database on such a system using the package designed for Mac OS X 10.6. Once you do so, you’ll have the tremendous power of the flexible MySQL relational database available to you for free. It’s an extremely useful database for both developers and system administrators. Here’s a step-by-step walkthrough of the process.
The version of MySQL you can get from the MySQL homepage doesn't seem to have the shared libraries needed to enable PHP to connect to MySQL. Thus, we'll have to compile MySQL ourselves. Tags: All-in-one, Aqua Data Studio, RazorSQL, DbVisualizer and Database Workbench, php, mysql, mysql Gui, Mysql Admin, mysql manager, mysql client 2. Navicat MySQL Manager for Mac OS X - Com 7.1.5. An ideal solution for MySQL administration and development.
I want to install the MySQL client for the command line, not a GUI. I have searched over the web but only found instructions on installing the MySQL server. Cloud Storage & Saved SQL Queries When you save your TeamSQL queries, they are then available to you no matter where you are. Powerful search functionality means that searching in the cloud is as easy as searching on your computer. Hi all, I run into an issue with upgrading MySQL. I am running Mac OS X v10.4.11 Server on a X-Server G5. The version of MySQL that came with the OS is Ver 14.7 Distrib 4.1.22, for apple-darwin8.0 (power pc). Nov 21, 2014 Any client for MySQL should work equally well for derived products, such as MySQL Enterprise, Percona Server, MariaDB, etc. Free Clients MySQL Workbench (Mac, Windows, Linux), Free, open-source.
Difficulty
Average
Time Required
0 minutes
Here's How to Install
- Download the 64-bit Apple Disk Image (DMG) installer for Mac OS X 10.6. While the download page says that the installer is for Snow Leopard (Mac OS X 10.6), it will work fine on Lion (Mac OS X 10.7) if you follow this process.
- When the download completes, double-click on the DMG file to mount the disk image. You will see an “Opening…” dialog appear. When it disappears, it will create what appears to be a new disk named mysql-5.5.15-osx10.6-x86_64 on your desktop.
- Double-click the new icon on your desktop. This will open the disk image in Finder and you’ll be able to browse the contents.
- Locate the main MySQL PKG file on the drive. It should be named mysql-5.5.15-osx10.6-x86_64.pkg. Note that there is also another PKG file called MySQLStartupItem.pkg, so make sure you’re selecting the correct one.
- Double-click the MySQL PKG file. The installer will open, showing you the initial page illustrated above. Click the Continue button to begin the guided installation process.
- Click the Continue button to continue past the Important Information screen. Click the Continue button to bypass the License Agreement screen (after thoroughly reading it and consulting with your attorney, of course!). The installer will also make you click Agree on a dialog box indicating that you really, really agree to the terms of the license agreement.
- If you would like to install MySQL in a location other than your primary hard disk, click the Change Install Location button to select your desired location. Otherwise, click Install to begin the installation process.
- Mac OS X will prompt you to enter your password to approve the installation. Go ahead and do so and the installation will begin. It will take a couple of minutes to complete.
- Once you see the message “The installation was successful,” you’re almost done! We have just a few more housekeeping steps to get it running. Click the Close button to exit the installer.
- Return to the Finder window that is open to the MySQL disk image. This time, double-click on the MySQLStartupItem.pkg PKG file. This will configure your system to automatically launch MySQL upon startup.
- Continue through the installation of the startup package item. The guided process is very similar to that used for the main MySQL installation.
- Return to the Finder window that is open to the MySQL disk image. On the third time around, double-click on the MySQL.prefPane item. This will add a MySQL pane to your System Preferences window, making MySQL easier to work with.
- You will be asked whether you wish to install the preferences pane only for yourself or whether you want all computer users to see it. If you choose the second option, you will need to provide an administrator password. Make your selection and click Install to continue.
- You will then see the MySQL preferences pane. You may use this pane to start and stop the MySQL server and also to configure whether MySQL will start automatically.
- Congratulations, you’re finished and can begin working with MySQL!
Tips
- Although the installer is labelled as only being compatible with Mac OS X 10.6 (Snow Leopard), it will work fine on Mac OS X 10.7 (Lion).
My Sql Client For Mac
What You Need
- MySQL installer for 64-bit Mac OS X 10.6
- Macintosh computer running Mac OS X 10.7
Featured Database Articles
slideshows
Updated January 28, 2016 / Posted July 29, 2015
By Rob Gravelle
Top 10 MySQL GUI Tools
Many third parties create rich applications to facilitate database management, database development and database administration. Here are ten outstanding graphical interfaces for MySQL.Workbench
Manufacturer: Sun Systems/Oracle
Website: http://dev.mysql.com/downloads/workbench/
Price: FREE
License: GPL License
Supported platforms: Microsoft Windows,Mac OS X and Linux
MySQL Workbench is avisual database design tool that integrates SQL development, administration, databasedesign, creation and maintenance into a single development environment. It isthe successor to DBDesigner 4 from fabFORCE.net and replaces the MySQL GUITools Bundle. The current version is 6.3, the earliest version being 5.0, which emphasized the fact thatMySQL Workbench was developed as the successor to DBDesigner4.
Navicat for MySQL
Manufacturer: Navicat
Website: http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html
Pricing: As follows:
* Enterprise version (Windows) ispackaged with Report Builder and Data Modeling Tool, and 2 Navicat ReportViewer licenses.
# Enterprise version (Mac and Linux) includes the Data Modeling Tool feature.A 14 day trial version isavailable.
License: Available under Commercial orNon-commercial licenses.
Supported platforms: Microsoft Windows,Mac OS X, Linux, and iOS
Navicat for MySQL is both a databaseadministration and development tool. It works with any MySQL database serverfrom version 3.21 or above, and supports most of the latest MySQL featuresincluding triggers, stored procedures, functions, events, views, and usermanagement.
Features in Navicat are sophisticated enough to cater to professionaldevelopers’ specific needs, yet easy to learn for users who are new to MySQL.
Sequel Pro
Manufacturer: The Sequel Pro Project (opensource)
Website: http://www.sequelpro.com/
Price: FREE (donations accepted via PayPal)
License: GNU GPL 2.0
Supported platforms: Mac OS X 10.6 SnowLeopard or newer
Sequel Pro is a FREE open-source application. It is thesuccessor of the CocoaMySQL Mac databasemanagement application. CocoaMySQL was the brainchild of Lorenz Textor, whowas the main developer of CocoaMySQL from its early beginnings in 2003.
Sequel Pro is an application used to manage MySQL databases(locally or over the Internet). It lets you add and remove databases andtables, change fields and indexes, view and filter table content, add, edit andremove rows, perform custom queries, and dump tables or entire databases.
It is compatible with MySQL 3.x, 4 or 5 and nowcomes in 5 additional languages, including Russian, German, Swedish, French andJapanese.
HeidiSQL
Manufacturer: Ansgar Becker
Website: http://www.heidisql.com/
Price: FREE (donations accepted via PayPal)
License: GNU General Public License
Supported platforms: Windows XP, Vista,7, 8, 10 (can be run on any Linux with Wine)
HeidiSQL, previouslyknown as MySQL-Front, is a FREE and open sourceclient developed by German programmer Ansgar Becker and a few othercontributors in Delphi. To manage databases with HeidiSQL, users mustlogin to a local or remote MySQL server with acceptable credentials, creating asession. Within this session users may manage MySQL Databases within theconnected MySQL server, disconnecting from the server when done. Its featureset is sufficient for most common and advanced database, table and data recordoperations but remains in active development to move towards the fullfunctionality expected in a MySQL Frontend.
A version written in Java, jHeidi, which isdesigned to work on Mac and Linux computers, also exists. Unfortunately, theproject has been discontinued since March 2010.
phpMyAdmin
Manufacturer: The phpMyAdmin Project (onSourceforge)
Website: http://www.phpmyadmin.net/home_page/
Price: FREE (donations accepted via PayPal)
License: GNU GeneralPublic License, version 2
Supported platforms: Microsoft Windows,Mac OS X and Linux, PHP 4 - 5 and MySQL 3 - 5
phpMyAdmin is a FREE software tool written in PHPintended to handle the administration of MySQL over the Internet. phpMyAdminsupports a wide range of operations with MySQL, the most frequently used beingthe managing of databases, tables, fields, relations, indexes, users,permissions. You still have the ability to execute SQL statements directly aswell.
Tobias Ratschiller, then an IT consultant andlater founder of the software company Maguma, started to work on a PHP-basedweb front-end to MySQL in 1998, inspired by Peter Kuppelwieser'sMySQL-Webadmin. He gave up the project (and phpAdsNew, of which he was also theoriginal author) in 2000 because of lack of time. By that time, phpMyAdmin hadalready become one of the most popular PHP applications and MySQLadministration tools, with a large community of users and contributors. Inorder to coordinate the growing number of patches, a group of three developers,Olivier Müller, Marc Delisle and Loïc Chapeaux, registered the phpMyAdminproject at SourceForge.net and took over the development in 2001.
SQLyog
Manufacturer: Webyog Inc.
Website: https://www.webyog.com/product/sqlyog
License: A full range of licensing options are available ranging from one to unlimited user commercial licenses with one year of free upgrades.
Supported platforms: Windows 2000, XP, Vista, 7, 10
There have been many complaints that MySQL Workbench hangsor fails to respond when put under a heavy load. SQLyog is a more robustproduct with many additional tools. It’s available in three major versions:Professional, Enterprise and Ultimate. The main difference between the threeversions is the number of included features. These include data migration,profiling, visual designers, analysis, batch scripting, backup scheduler, user manager,and database copy tools.
At this time, SQLyog is only available for the Windows platform, but, some of the community uses it on MacOS, Ubuntu, Debian, Fedora and Mageia using WINE.
A single user license costs $99 for the Professional Ed, $199 for the Enterprise Ed, and $299 for the Ultimate Ed. Multi-user packages are also available. A 14-day trial version of SQLyog is available for download from the Webyog's website.
Updated: April 28, 2017
SQLWave
Manufacturer: Nerocode
Website: http://www.sqlwave.com/
Price: $99.00 USD
License: shareware. See http://www.sqlwave.com/Content/Other/license.txtfor more details.
Supported platforms: Windows XP, Vista, 7, 8, 10
Nerocode SQLWave is a MySQL GUIClient tool designed to automate and simplify the database development process.It also provides an easier way to explore and maintain existing databases,design compound SQL statements, query and manipulate data in different ways. MySQL4.x - 6.x compliant.
A 30 day trial version isavailable.
dbForge Studio
Manufacturer: devart
Website: http://www.devart.com/dbforge/mysql/studio/
Price: FREE for express edition, $59.95(non-commercial standard edition), $124.95 (non-commercial professional edition),$119.95 (commercial standard edition), $249.95(commercial professional edition)
License: Commercial and non-commerciallicenses available. Subscriptions are also offered as an efficient andquickest way to deliver product upgrades and technical support.
Supported platforms: Windows XP/7/8/8.1/10
dbForge Studio for MySQL offers visual MySQL development andadministration.
There are three editions: Express, Standard, andProfessional:
Express is a FREE application that provides basicfunctionality for working with schema objects, user accounts, SQL scripts, andqueries.
Standard includes additional tools for databaseadministrators and developers, such as a debugger, Query Builder, codetemplates, object search, various export and maintenance wizards.
Professional is the most full-featured version andadds the following functionality: database projects, accurate comparison andsynchronization of database structures (schema comparison) or database content(data comparison), debugging stored procedures and scripts, complex querycreation.
Other tools from dbForge include:
- Schema Compare for MySQL
- Data Compare for MySQL
- Query Builder for MySQL
- Fusion for MySQL
DBTools Manager
Manufacturer: DBTools Software Grindr client for mac.
Website: http://www.dbtools.com.br/EN/dbmanagerpro/
Price: Standard Edition is FREE. Enterprise is$69.90 USD for a single license. Discounts are available for multiplelicenses.
License: Standard Edition is licensed understandard freeware conditions. The enterprise version is licensed per unitsold.
Supported platforms: Windows 2000, XP, Vista, 7
Standard Edition
Specially designed for personal use, it has a minimumset of features that makes it ideal for new database users to perform basicdatabase management. You can use this edition for FREE for non commercial use.For commercial use you can purchase a license which will provide additionalfeatures.Enterprise Edition
Designed for Enterprise use, it is more suited for DBAs and developerslooking for an integrated application for database management. You can try itbefore purchasing. The Enterprise Edition trial version comes with all featuresenabled, so that you can try them all for 20 days and make your purchasingdecision based on the full experience.Both include Support for MySQL 3, 4 and 5.
MyDB Studio
Manufacturer: H2LSoft,Inc
Website: http://www.mydb-studio.com
Price: FREE
License: freeware
Supported platforms: Windows, XP, Vista, 7, 8, 10
Our final entry is another studio containing a completecollection of tools for MySQL Server administration. Developers willappreciate its ability to create/edit/drop database objects, DBsynchronization, and data export/import. DBAs can also use MyDB Studio toperform database migration, as well as backups and restores. It supports SSHtunneling to secure your connections, which allows you to connect even if yourhost doesn't allow you remote access connection, user and privilege management,and PHP script creation.
Conclusion
Runner-Ups
Of course not every beloved MySQL product could make it onthe list. Here are a few more for your consideration:
I am confident that you will find a product to suit yourneeds in this group. They are in no particular order, so feel free to try anythat catches your eye. I should also point out that I received absolutely nofinancial compensation from any of these companies. My assessment of eachproduct is based on my unbiased opinion. As such, my top ten list may divergeslightly from the general consensus.
A few things have changed in the database landscape since our Top 10 MySQL GUI Tools list was compiled--in particular the emergence of cloud services. Keep that in mind when searching for the right MySQL admin tool.
Mysql Server Community Download
Most relational databases, with the notable exception of MS Access, are comprised of two distinct components: the back-end, where the data is warehoused, and the front-end, a user interface for communicating with the data component. This type of design is quite clever, as it parallels the two tier programming model that separates the data layer from the user interface and allows the makers of the database software to focus on their product’s strongest suit: data storage and management. It also opens the door for third parties to create rich applications to interact with various databases. Such products include Embarkedaro Rapid SQL and Oracle SQL Developer. Here are ten outstanding graphical interfaces for MySQL.
