Util: Setup For MySQL & PostgreSQL

[joelin109]

• Mac
  • How to fix: "'App' is damaged and can't be opened. You should move it the the trash."

    sudo spctl --master-disable

MySQL

• Mac

---

• Install MySQL

download `MySQL Community Server`  from http://www.mysql.com/downloads/

install mysql-5.*-osx*-1-x86_64.dmg
Alert `MySQL installer` including  temporary password during installing

then you will see `MySQL` pane in `System Preferences`

• Install MySQL-Workbench

download `MySQL Workbench`  from http://dev.mysql.com/downloads/workbench/

install mysql-workbench-*.dmg

open `MySQL Workbench`,  add one `MySQL Connection`

then need update default password for root User.  
make sure that `Test Connection`  can work well

• Install Navicat Premium

[joelin109]

PostgreSQL

• Mac

  • Download Postgres

    
    download `Postgres.app` from http://postgresapp.com/

Move to /Applications

- Setting PATH for `Postgres`

sudo vi .zshrc

export PATH=$PATH:/Applications/Postgres.app/Contents/Versions/14/bin

• i 编辑; esc结束；: wq 存储离开

<br>
<br>

- Basic Command
`psql` `which psql` `\du` `\l` `

\q - su postgres - psql (switch to other admin user)

\du alter user postgres with password 'XXXXXX'; create user user1 with password '123456'; drop user user1;

\l create database db1; drop database db1;

• Run Postgres.app first

• Navicat Premium

  add `New Connection` for `PostgreSQL`