Detailed process of installing and configuring MySQL and Navicat prenium

Prerequisite: Mac, zsh installed, mysql downloaded when it was bash, deleted it and downloaded it again.

mysql

download

Download address: https://dev.mysql.com/downloads/mysql/

If you don't care about the version, just download the dmg file here. If you care about the version, you can choose the version in Archives (I only remembered whether I should check the version after I downloaded it. I'm still in the initial learning stage, so I'll just use this one...)

Choose this to download directly without logging in or registering, which is more convenient

Install

This step may be different because mysql has been downloaded on this computer before. To reinstall, just agree to the installation all the way down. In the last step, I did not see the temporary password for MySQL pop up. It provided two options, one was to choose a strong password, and the other was to choose the old password. I chose 1 and directly set the MySQL password in this step. I can log in directly later without resetting the password.

Configuration

1. Look at the prompt on the terminal directly, or enter echo $SHELL to see what type of shell it is

2. Execute code

vim ~/.bash_profile
# This step prompts open read-only/edit aniway/recover/delete it/quit/abort, just enter the first letter, select E

3. Enter the file and enter

export PATH=${PATH}:/usr/local/mysql/bin

4. Press ESC to exit the edit mode and enter :wq to save and exit
5. Execute code

source ~/.bash_profile

6. Exit and restart the terminal, enter mysql , if the following picture is displayed, it means the installation is successful

7. If it displays command not found:mysql, continue to execute (Note: By checking the shell, you can know that it is zsh, so in addition to /.bash_profile , you also need to configure /.zshrc )

# 7.1
# Open the file vim ~/.bashrc
# Input alias mysql=/usr/local/mysql/bin/mysql
# Press esc to exit edit mode and enter :wq to save and exit # Enter source ~/.bashrc

# 7.2
# Open the file vim ~/.bash_profile
# Type source ~/.bashrc
# Press esc to exit edit mode and enter: wq to save and exit source ~/.bash_profile

# 7.3
# Open the file vim ~/.zshrc
alias mysql=/usr/local/mysql/bin/mysql
# Press esc to exit edit mode and enter :wq to save and exit source ~/.zshrc

Navicat premium download

Download address: https://www.jb51.net/article/199496.htm

The above is the detailed content of the detailed process of installing and configuring MySQL and Navicat Premium. For more information about MySQL Navicat Premium installation and configuration, please pay attention to other related articles on 123WORDPRESS.COM!