MAC install MySQL and DBeaver（转载）

MAC install MySQL and DBeaver（转载）

源地址：https://alessiazm.wordpress.com/2021/08/14/mac-install-mysql-and-dbeaver/

Install MySQL

1、Download MySQL dmg

Here is the dmg (mysql-8.0.26-macos11-x86_64.dmg)

2、Install MySQL

instal the mysql.dmg step by step.

And set the password at the configuration step.

3、Config the path

vim ./.bash_profile

Add the mysql path below and save

export PATH=$PATH:/usr/local/mysql/bin
export PATH=$PATH:/usr/local/mysql/support-files

source ~/.bash_profile

Then, you could try type mysql to confirm whether installed.

4、 Go the db directory

cd test_db

5、 Use mysql command line

mysql -u root -p < employees.sql

Install DBeaver

Download the DBeaver via the net

Download

And Install step by step！

Open DBeaver and connect the sql.

Click next, type the password u just set and confirm.

Then, the test_db is imported and sawn.