MySQL is a relational database management system. MySQL is the widely used database server in the world. This tutorial helps you to install MySQL database server on macOS Sierra 10.12 and High Sierra 10.13 and other supported versions using Homebrew.
Apr 20, 2020 Ability to connect to MySQL database via an SSH tunnel, in case you don’t have the default port open for remote connections. The Ultimate version comes with a good data comparison tool. Cons: High price point for the professional version. Some users report occasional software crashes. Lack of support for databases other than MySQL.
Step 1 – Prerequisites
Before starting the installation of MySQL using this tutorial you must have the following prerequisites
Mysql 5.5 For Mac Os Download
- Terminal: You must have Mac Terminal access and little knowledge about working with the terminal application.
- Homebrew: Homebrew is a popular package management tools used for installing most open source software like Node. Here is the Homebrew installation tutorial
Step 2 – Install MySQL on macOS
Mysql 5.5 For Mac Os 1
At this time of writing this tutorial, Homebrew has MySQL 5.7.21 version in its main repository. Start a terminal and run command to install MySQL:
Wait for the installation process finish. Now you just need to configure things so that your MySQL server is auto-started
Also, you have to set a strong password for the MySQL root account. Use the following command to set a new password. Make sure to use a strong password.
Step 3 – MySQL Configuration
MySQL server has been installed on your system. The binary files are installed under /usr/local/bin directory and all the MySQL related files are created under “/usr/local/var/mysql” directory. The main confiugration file is created at:
You can use above file to customize your MySQL server. Now, Connect to MySQL server using the command:
Step 4 – Manage MySQL Service
There are mysql.server command available under /usr/local/bin directory, which is used to manage MySQL service. You can use mysql.server command with options status, stop, start, or restart MySQL service on your system.
All done. You have running MySQL server on your system. What next? Visit our MySQL tutorial section to create and manage databases from the command line.
Latest Version:
Requirements:
Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64
Author / Product:
Oracle / MySQL (64-bit)
Old Versions:
Filename:
mysql-5.6.30-winx64.msi
MD5 Checksum:
83821f4ac671ddd65b049941f9f3c8cf
If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML, or other formats to the program.
MySQL Database Server delivers new enterprise features, including ACID Transactions to build reliable and secure business-critical applications. Stored procedures to improve developer productivity. Triggers to enforce complex business rules at the database level. Views to ensure sensitive information is not compromised. Information schema to provide easy access to metadata. Distributed transactions (XA) to support complex transactions across multiple databases.
Top 10 Reasons to Use MySQL:
Scalability and Flexibility
The MySQL 64 bit database server provides the ultimate in scalability, sporting the capacity to handle deeply embedded applications with a footprint of only 1MB to running massive data warehouses holding terabytes of information.
High Performance
A unique storage-engine architecture allows database professionals to configure the database server specifically for particular applications, with the end result being amazing performance results.
High Availability
Rock-solid reliability and constant availability are hallmarks of the app, with customers relying on the program to guarantee around-the-clock uptime.
Robust Transactional Support
It offers one of the most powerful transactional database engines on the market. Features include complete ACID (atomic, consistent, isolated, durable) transaction support, unlimited row-level locking, and more.
Web and Data Warehouse Strengths
The tool is the de-facto standard for high-traffic web sites because of its high-performance query engine, tremendously fast data insert capability, and strong support for specialized web functions like fast full-text searches.
Strong Data Protection
Because guarding the data assets of corporations is the number one job of database professionals, It offers exceptional security features that ensure absolute data protection.
Comprehensive Application Development
One of the reasons the app is the world's most popular open-source database is that it provides comprehensive support for every application development need. Within the database, support can be found for stored procedures, triggers, functions, views, cursors, ANSI-standard SQL, and more.
Management Ease
The software offers exceptional quick-start capability with the average time from software download to installation completion being less than fifteen minutes.
Open Source Freedom and 24 x 7 Support
Many corporations are hesitant to fully commit to open source software because they believe they can't get the type of support or professional service safety nets they currently rely on with proprietary software to ensure the overall success of their key applications.
Lowest Total Cost of Ownership
By migrating current database-driven applications to My SQL, or using It for new development projects, corporations are realizing cost savings that many times stretch into seven figures.
Also Available: Download MySQL for Mac