MySQL Configuration for Mac version

Start download

I chose the last DMG format installation package, click Download, will appear let us register login interface, click the bottom of the no thanks,just take I to downloads! directly download can:

Download Complete for installation

Open the downloaded installation package and click on the last file to install it, all the way next:

Installation Complete

After the installation is complete, a session box will pop up, which will tell us the root user's initial password, and don't ignore it.

Installation Inspection

After installation, open the preferences, check whether the MySQL has been installed, the landlord's MySQL seems to be installed successfully, OH Also

Start MySQL

Start or stop MySQL by clicking MySQL in Preferences

Of course, you can also directly double-click (Two-finger click to know) for quick access

MySQL Workbench Download

• MySQL Workbench is a software, is a GUI (graphical User Interface) tool.

Access to the website download interface

Download MySQL Workbench website from the official website
This place has the choice phobia the friend to be more comfortable, does not need to choose, after all only one

Download Complete for installation

Double-click the installation, you can see it in the application after the installation, Launchpad

Open it and you'll see the following main interface:

Make a connection to the database create a new connection

Click on the title MySQL connections to the right of the + button to create, Connection Name can write casually, here as a test is called ConnectionTest1:

Created successfully

You can see all the connections created on the home page

Open connection

Double click to create a good connection, the password will appear let us fill in the root, of course, the password here is the previous installation of MySQL successfully, the system prompts us the default password (although the password is very cumbersome 0.0)

Input correct after the system will ask us to change the password, after all, the password is too troublesome, anyway, the landlord is unable to remember

Modify password successfully

After the password is modified, click on the created connection and enter the modified password to enter the main visual interface:

Add user

If you need to add users, of course, it is also possible.

Uninstall MySQL

• How to uninstall MySQL, after all it does not come out of the application as well as Launchpad in the installation disk also does not give us uninstall files.

Enter the following code in the terminal can be completely deleted MySQL, landlord or recommend all copies to the terminal, simple violence (remember to close the MySQL service OH):

sudo rm/usr/Local/mysqlsudo RM-rf/usr/local/mysql*sudo RM Span class= "Hljs-attribute" >-rf/library/startupitems/mysqlcomsudo rm -rf/library/ Preferencepanes/my*vim/etc/hostconfig (and removed the line Mysqlcom=-yes-) rm -rf ~/Library/ Preferencepanes/my*sudo rm -rf/library/receipts/mysql*sudo rm -rf/library/receipts/mysql* sudo rm -rf/var/db/receipts/com .mysql. * 

MySQL configuration for Mac version