Category: DB

bookmark_borderInstall MySQL

Posted on by Jay Jo

Introduction

MySQL is SQL database

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.

Learn more: https://en.wikipedia.org/wiki/MySQL

Contents

  1. Install MySQL Community Edition on Mac

1. Install MySQL Community Edition on Mac

What is MySQL Community Server?

MySQL Community Edition is a freely downloadable version of the world’s most popular open-source database that is supported by an active community of open source developers and enthusiasts.

Download & Install DMG Archive file from https://dev.mysql.com/downloads/mysql/

Click Open Anyway for installing mysql
  • mysql & mysql-version(mysql-8.0.21-macos10.15-x86_64) folder will be created in /usr/local

Add path for mysql

$ vi ~/.bash_profile
# MY SQL
export PATH="$PATH:/usr/local/mysql/bin"

You should set up root password. 

$ mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpassword';
Query OK, 0 rows affected (0.10 sec)
  • You should set up root password.
ANOTE.DEV