20220531-在新mac上安装OpenJDK+Mysql及设置密码+Sequel Pro总结回顾

Backgroud

I am helping my colleague to install JRE ,mysql and Sequel Pro(rather than Navicat) on her laptop and it’s a review to look back what I learned last month.

Install MySQL

https://downloads.mysql.com/archives/community/

choose a suitable version for your laptop.

Another way to install Mysql:

• Officials url on https://brew.sh/

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

• 5 mirror sources in China mainland:

/bin/zsh -c "$(curl -fsSL https://gitee.com/cunkai/HomebrewCN/raw/master/Homebrew.sh)"

After finished installation,we may to reset the password and username.

• enter into mysql/bin/

cd /usr/local/mysql/bin/

• Skip grant tables

# 顾名思义，就是在启动mysql时不启动grant-tables，授权表
sudo ./mysqld_safe --skip-grant-tables

• Open a new window of terminal

#enter into mysql/bin/
cd /usr/local/mysql/bin/


./mysql

#mysql> SQL SYNTAX~~~ it's a mush to flush privileges.
FLUSH PRIVILEGES;

#mysql> SQL SYNTAX~~~ set password as 123456 ,you can directly replace it
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

#finally restart mysql service
sudo /usr/local/mysql/support-files/mysql.server restart

#stop mysql service(optional)
sudo /usr/local/mysql/support-files/mysql.server stop

#start mysql service(optional)
sudo /usr/local/MySQL/support-files/mysql.server start

Install Zulu JDK

https://www.azul.com/downloads/

I am lazy to download JDK from oracle as you need to login every time when you want to download.——That’s why I choose Zulu JDK. Choose a suitable version for your laptop.It’s easy to install as long as you follow the guide.

Install Sequel Pro

#97c1b85783 
https://sequelpro.com/test-builds