How to install MySQL on a Mac?

1 year ago
Noah Thompson
2 minutes

To install MySQL on Mac, you can follow these steps:

  1. Download the MySQL installation package: Visit the official MySQL website (https://dev.mysql.com/downloads/mysql/) to download the MySQL installation package for Mac. Choose the appropriate version and operating system version.
  2. Install MySQL: Double click on the downloaded installation package and follow the prompts to complete the installation. Choose custom installation and installation location in the installation wizard.
  3. Start the MySQL server by opening “System Preferences”, clicking on the “MySQL” icon, and selecting “Start MySQL Server”.
  4. Set up MySQL administrator password: After starting the MySQL server, a command line terminal window will appear prompting you to enter a temporary administrator password.
  5. Set up MySQL: Open the terminal application and configure MySQL using the following command:
  6. Please run the mysql_secure_installation script located at /usr/local/mysql/bin/mysql_secure_installation using sudo.
  7. This will guide you through some basic configurations for MySQL, such as changing the administrator password and deleting anonymous users.
  8. To start and stop the MySQL server: Use the following commands in the terminal to start and stop the MySQL server:
  9. Begin/End MySQL server by running these commands as a superuser:
    Start MySQL server: sudo /usr/local/mysql/support-files/mysql.server start
    Stop MySQL server: sudo /usr/local/mysql/support-files/mysql.server stop

Now that you have successfully installed MySQL on your Mac, you can manage and operate MySQL databases using the MySQL command-line tool (mysql) or graphical interface tools like phpMyAdmin.

bannerAds