Mysql installation Configuration method under the Mac graphics and text tutorial _mysql

First, download MySQL

Visit MySQL's official website http://www.mysql.com/downloads/and then see a "Download" click under MySQL Community Server on the page.

Enter the MySQL download interface (http://www.mysql.com/downloads/mysql/), if you are using the Mac OS to access the words then will be the default for you to choose the Mac OS X platform, and listed below are all in the Mac The version of MySQL available on the OS, if it's a different platform, select the Drop-down list for the Select Platform option.

There are a lot of MySQL versions on Mac OS, including platforms like 10.5/10.6, and then 32-bit and 64-bit, which you choose according to your own system, And then there's the suffix of the file with. tar.gz and. DMG, and here's what I chose. dmg. Click on the download on the right to download.

Then will jump to another interface, this interface is prompted you need not register, directly select the bottom of the "no thanks,just Take Me to downloads!", and then this really jump to the download interface, this interface lists a lot of servers for downloading, Select a server to download on the OK.

Second, the installation of MySQL

To open the MySQL installation package:

Install separately

Mysql-5.5.16-osx10.6-x86_64.pkg: This is the main package of MySQL;

MYSQL_STARTUPITEM.PKG:MYSQL of the start item;

Mysql.prefpane: After installation will appear in the System Preferences, is MySQL preferences, which is mainly used to start the MySQL service.

Third, download and install MySQL Workbench (GUI Tool)

3.1 MySQL Workbench Download

Access to http://www.mysql.com/downloads/below is a MySQL Workbench (GUI Tool) entry, click on the download to enter the download interface:

Then select the server to download after the same version. There seems to be only one version:

Installation of 3.2 MySQL Workbench

After the download is complete, the installation is very simple, double-click to install. Once the installation is complete, we can see the MySQL Workbench.app program in the application. Double-click to open:

MySQL Workbench here to install the finished.

After the installation is complete, we'll talk about MySQL Workbench connected to MySQL's database and then manage the database.

3.3 Establish a new connection

You can see that the MySQL Workbench main interface has three modules, the SQL development,data modeling,server administration. One of the "new Connection" clicks on the SQL development is followed by a dialog box for "Setup New Connection", after completing connetion name, click OK. You can complete a connection to the local database.

When you are done, the connection that you just established will appear in the main interface, as shown in the following figure:

When you double-click the connection name or select a connection and click Open Connection to Start querying, you are ready to enter the interface of the operation database:

All of these prerequisites are that the database service has to be opened.

3.4 Access password for admin database

MySQL default account password is root/root, under normal circumstances, if we simply use MySQL Workbench to manage the database of this account is OK, but when we are in the programming code through JDBC to access MySQL we will find that the use of this account is not , unable to access because MySQL requires us to change the password, which means that the root is a default password is a weak password, we need to modify to use in the code. So we need to manage the access password for the database.

Create a new server Instance

A "Create New server Instance Profile" dialog box appears after a "New server Instance" click in the "Server Administration" module, followed by a step-by-Step dialog box, The general local database directly follows the default setting on OK. Once we're done, we'll be able to see the instance on the far right of Workbench's main interface.

Double-click to open the manager, here need a password, the general has not changed is root. Then there is a submenu of "Users and Privileges" under "Security" under the menu bar on the left, and you will see the following interface:

In the Panel on the right there is a list of user accounts, select the account in which you want to modify the password, and then modify the password on the right.

The above is the Mac under the MySQL installation configuration method, I hope to help you learn.