MySQL + mysqlworkbench + pycharm installed under Mac

MySQL + mysqlworkbench + pycharm installed on Mac today

Installing these things is not familiar under Windows.

Under the MAC installation program really is not very suitable, feel very uncomfortable!!! After the installation is quite happy, you can do the things you want to do.

By looking at a variety of information, to install these things. Finally, after a few twists and ends the installation is complete. Here is a simple record of the installation process and the problems encountered.

First, download mysql and MySQL Workbench

http://dev.mysql.com/downloads/mysql/  

Choose the appropriate MySQL installation package for your Mac version (there are many versions)

http://dev.mysql.com/downloads/workbench/  

Choose the same MySQL Workbench version as the MySQL installation package downloaded above (but there is only one version here, so this is the case)

Second, download mysql and MySQL Workbench

2.1 Installing MySQL

To open the MySQL installation package:

And for some of the main programs that will appear MySQL are two other packages such as:

MYSQL_STARTUPITEM.PKG:MYSQL start-up items;

Mysql.prefpane:

There's only mysql-5.6.20-osx10.8-x86_64.pkg here. Because you will see the above two items when you install it later, you can choose whether to install it according to your needs.

after the installation is complete, start the MySQL service

1, if you have installed the MYSQLSTARTUPITEM.PKG, restart the computer.

2, if you have installed mysqlstartupitem.pkg or do not want to start the computer

Open terminal, enter command: sudo/library/startupitems/mysqlcom/mysqlcom start, then enter your system administrator password.

Turn off MySQL service

Enter the command in Terminal: sudo/library/startupitems/mysqlcom/mysqlcom stop, then enter your system administrator password.

You can also go to System Preferences-other-mysql, through which to start and stop the MySQL service.

Terminal login MySQL

Method 1: Absolute path

Terminal input command:/usr/local/mysql/bin/mysql-u root-p

Tip: Enter your new password

Method 2: (recommended) relative path

Enter the command in the terminal:

To see if there is a path in the path:

Input command in terminal: Echo $PATH

No, go ahead.

Add Required path: path= "$PATH":/usr/local/mysql/bin

later

Input command in terminal: Mysql-u root-p can be

Password issues

Problems that may occur if a password is not set when the terminal is viewing the database

ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' MySQL '

On the internet for a long time, finally found that because the user table of MySQL database, there is a username is empty account is anonymous account, resulting in the log-in when the use of root, but is actually anonymous login

Changing the MySQL root account password will solve this problem

Terminal input command:/usr/local/mysql/bin/mysqladmin-u root password new password

You can change your password at any time by using this command.

Terminal login MySQL

Input command in terminal:/usr/local/mysql/bin/mysql

2.2 Installing MySQL Workbench

After the download is complete, the installation is simple and can be installed by double-clicking. After the installation is complete, we can see the MySQL Workbench.app program in the "Application". Double-click Open

The MySQL Workbench is installed here.

After the installation is complete we will talk about MySQL Workbench connected to the MySQL database and then manage the database.

Third, installation Pycharm

http://www.jetbrains.com/pycharm/download/  

Community Edition Free for Mac OS X

The Pycharm is also installed. Although it feels not very good, but see the interface editing environment I immediately like it.

Install the installation directly.

The problem that has been tangled is not installing the Pycharm Python IDE but choosing which of the more appropriate Python ides to support Mac OS X systems.

http://blog.csdn.net/mac_cm/article/details/2403686

Introduction to several Python development tools