Shulou(Shulou.com)06/01 Report--

This article is about how mac installs mysql graphical tools. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Mac installation method of mysql graphical tool: first download the installation file of mysql graphical tool Navicat Premiun; then click the downloaded dmg file, drag it to the application folder to install, and operate step by step according to the instructions of the installation instructions interface.

Mac download and install mysql and graphics tools Navicat Premium 1, download and install mysql1.1, download mysql

(1) Software download address: https://dev.mysql.com/downloads/

Select: MySQL Community Server

(2) Click to enter the download interface: select MacOS system, select macOS 10.13 (x86, 64-bit), download button corresponding to DMG Archive, and click download.

(3) enter the next download interface, log in to download or download directly without logging in.

(4) download the file after completion

1.2. install mysql

(1) Click the dmg file and click all the way (special note: some version will pop up to tell you the accident password, please remember this password. There are also some parts that will let you set your own password, more than 8 digits, the version I downloaded is to set your own password)

After installation, you can see the mysql icon in the system preferences.

(2) Click the mysql icon, and the following interface appears to enable mysql operation: open mysql, change password, uninstall, etc.

(3) configure mysql

A, open the terminal: just open the focus search. Type cd / usr/local/mysql/bin, and then ls to view the directory. Check to see if there is a mysql in this directory.

B. Enter vim ~ / .bash_profile to open the .bash _ profile file

C. Add PATH=$PATH:/usr/local/mysql/bin to the displayed file

D, input: source ~ / .bash_profile, use mysql-u root-p

Enter mysql and enter the password you set. The content in the large box below indicates success.

Installation of mysql is complete

Download and install Navicat Premiun

Navicat Premium for mac is a database management tool that can be connected to multiple connections. The function of Navicat is sufficient to meet all the needs of professional developers, but it is quite easy for novice database servers to learn. It allows you to connect to all the mainstream databases in the world at the same time and manage and operate with a single program. The supported databases are: MySQL, SQL Server, SQLite, Oracle and PostgreSQL. Make it more convenient to manage different types of databases.

Navicat Premium combines the capabilities of other Navicat members. With the connection capabilities of different database types, Navicat Premium supports data transfer between MySQL, SQL Server, SQLite, Oracle, and PostgreSQL. Including stored procedures, events, triggers, functions, views, etc.

Navicat Premium is available on three platforms-Microsoft Windows, Mac OS X and Linux. It allows users to connect to local or remote servers and provides some practical database tools such as data model tools, data synchronization, structural synchronization, import, export, backup, restore and reports to help manage data.

download

My software installation package sharing: Baidu network disk link and password:

Link: https://pan.baidu.com/s/1QW950KP0ItxYylgTpwksvA password: ygey

Installation

When the download is complete, click on the downloaded dmg file and drag it to the application folder for installation.

3. Navicat connects to the database

Here is the connection to the local mysql

First open the installed navicat, click the connection in the upper left corner, and select mysql.

A pop-up window to fill in the connection properties appears, and enter the following in the pop-up window.

(3) if the connection fails to report an error client does not support authentication protocol requested by server consider. Then please continue to read the wrong solution.

A, terminal connection mysql

[mysql-u root-p]

B, enter the following statement at the terminal, and remember to change the password in the statement to your own mysql connection password. [ALTERUSER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password';]

C, terminal input refresh statement [FLUSH PRIVILEGES;]

Reconnect, success, error resolution.

Ending-, remember to order a compliment.

Thank you for reading! On the mac installation of mysql graphical tools to share here, I hope that the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.