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.
Step 1 – Prerequisites
Before starting the installation of MySQL using this tutorial you must have the following prerequisites
Step 2 – Install MySQL on macOS![]()
Sep 23, 2016 The latest version of MySQL 5.7.16 does work with the public release of macOS. If you already have MySQL 5.7 and you have upgraded OS from El Capitan to Sierra I expect that to be ok, but will be interested if anyone comments on that. Use the Mac OS X 10.11 (x86, 64-bit), DMG Archive version (works on macOS Sierra). Jan 24, 2019. Mar 30, 2018. Jul 31, 2020 For the strongest security and latest features, find out whether you can upgrade to macOS Catalina, the latest version of the Mac operating system. If you still need macOS Sierra, use this link: Download macOS Sierra. A file named InstallOS.dmg will download to your Mac.
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 ServiceDownload Mysql Mac Os Sierra Os
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.
Mac Os Sierra Download Pc
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.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |