Install MySQL

All downloads for MySQL are located at MySQL Downloads. Pick the version number of MySQL Community Server which is required along with the platform you will be running it on.

Installation on macOS

Configuration

Connect

Using Terminal

You can connect to MySQL via terminal, take macOS as an example:

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 8.0.22 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

info

If it returns command not found: mysql in terminal, you can add export PATH=${PATH}:/usr/local/mysql/bin/ in ~/.zshrc and run . ~/.zshrc at last.

In addition, we recommend mycli which is a command line client for MySQL that can do auto-completion and syntax highlighting.

• HomePage: http://mycli.net
• Documentation: http://mycli.net/docs

Install mycli:

brew install mycli  # Only on macOS

Connect to MySQL:

Using TablePlus

TablePlus supports a whole set of relational databases (and some NoSQL). Comparing to other database tools, it's very FAST and EASY TO USE. For example, it can return result sets in a short time even if there are large fields such as blob type.

tip

You can check the connection by clicking Test before establishing a formal connection.