MySqL + MySQLWorkbench + PyCharm and mysqlworkbench are installed on mac.
Today, MySqL + MySQLWorkbench + PyCharm is installed on mac.
Installing these things is not familiar with windows.
The installation program on Mac is really not very suitable, and it feels very uncomfortable !!! After the installation is complete, I am very happy. I can do what I want to do later.
Install these things by reading a variety of materials. After some twists and turns, the installation is complete. The following is a simple record of the installation process and problems encountered.
I,Download MySQL and MySQL Workbench
Http://dev.mysql.com/downloads/mysql/
Select the MySQL installation package for your Mac version (there are many medium versions)
Http://dev.mysql.com/downloads/workbench/
Select the MySQL Workbench version that is the same as the MySQL installation package downloaded above (but there is only one version here, so click this)
II,Download MySQL and MySQL Workbench
2.1 install MySQL
Open the MySQL installation package:
For some major MySql programs, the other two packages are as follows:
MySQL_StartupItem.pkg: MySql startup item;
MySQL. prefPane:
There is only mysql-5.6.20-osx10.8-x86_64.pkg. Because the above two items will be displayed during subsequent installation, and you can choose whether to install them as needed.
After the installation is complete,Start mysql Service
1. If you have installed MySQLStartupItem. pkg, restart your computer.
2. If you have installed MySQLStartupItem. pkg or do not want to start your computer
Open the terminal, enter the command: sudo/Library/StartupItems/MySQLCOM start, and then enter your system administrator password.
Disable mysql Service
Enter the command sudo/Library/StartupItems/MySQLCOM stop in the terminal, and enter your system administrator password.
You can also go to system preference settings-other-MySQL to start and stop the MySQL service.
Terminal login mysql
Method 1: absolute path
Enter the command in the terminal:/usr/local/mysql/bin/mysql-u root-p
Tip: enter your new password.
Method 2: (recommended) Relative Path
Enter the following command in the terminal:
Check whether the required path is in the path:
Enter the command echo $ PATH in the terminal.
No, continue
Add the required PATH: PATH = "$ PATH":/usr/local/mysql/bin
Later
Enter the mysql-u root-p command in the terminal.
Password Problems
Problems may occur if no password is set when you view the database on the terminal
ERROR 1044 (42000): Access denied for user ''@ 'localhost' to database 'mysql'
After searching online for half a day, I finally found that the user table of the mysql database contains an account with an empty username, namely an anonymous account. As a result, the root account is used for logon, but it is actually Anonymous logon.
You can solve this problem by changing the mysql root Account Password.
Enter the command in the terminal:/usr/local/mysql/bin/mysqladmin-u root password New password
You can use this command to change your password at any time.
Terminal login mysql
Enter the command/usr/local/mysql/bin/mysql in the terminal.
2.2 install MySQL Workbench
After the download is complete, the installation is very simple. You can double-click it to install it. After the installation is complete, we can see the MySQL Workbench. app program in the "application. Double-click to open
MySql Workbench has been installed.
After the installation is complete, we will talk about connecting MySQL Workbench to the MySQL database and then managing the database.
3. Install PyCharm
Http://www.jetbrains.com/pycharm/download/
Community Edition FREE for mac OS x
PyCharm is also installed. Although it was not very nice, I immediately liked the interface editing environment.
Install directly
The persistent issue is not to install Pycharm Python IDE, but to choose which Python IDE is more suitable and supports mac OS X.
Http://blog.csdn.net/mac_cm/article/details/2403686
Introduction to several Python development tools
I have installed mysql on mac OS x 1083, but I don't know which password is used to change the password of mysql.
The default account password is root.
We recommend that you install another MySQLWorkbench for operations, account addition, and other operations.
Hope to help you
Why cannot I enable MySqlWorkbench after it is installed?
A file is missing. Download this file from Microsoft. NET Framework.