Download install MySQL1. Visit MySQL website: http://dev.mysql.com/downloads/2. Download MySQL Community server:3.select Platform The default is Mac OS. , choose your favorite suffix file to download, I choose Dmg:4. You can choose the bottom "no thanks,just take Me to downloads!", and then download: 5. Double-click the downloaded DMG and double-click the pkg to install: Requires 1.16g: 6. Installation Complete, note the password: 7. In System Preferences, you can start mysql: double-click MySQL, start: 8. Enter the following code in the terminal, You can see the MySQL folder: $ cd/usr/local Enter the following code, login to MySQL, but error command not found:$ mysql-uroot-p-bash:mysql:command not found directly write full The path can be logged in: $/usr/local/mysql/bin/mysql-uroot-p After entering the password, the login succeeds: exit mysql:mysql> \ Q with GUI interface Workbench manage MySQL database Quora on the list of the better clients, I choose MySQL workbench:what is the best MySQL client for Mac OS X or windows?1. Login my SQL official website, download workbench:http://dev.mysql.com/downloads/workbench/ 2. After you drag the installation: installation is complete, MySQL Workbench.app can be seen in the application. Click to open: 3. Next, connect the MySQL workbench to the MySQL database, and then manage the database. Click "MySQL Connections" to the right of the plus sign, fill out connetion name and password after clicking OK, the other is the default. Can complete a connection to the local database connection: added, the main interface will appear on the connection just established: click on the connection, the password expiration prompt, change password: 4. Enter this database with a new passwordInterface: then you can go to the official website to see the guide to learn how to use the:http://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
[Email protected] ~]#/usr/local/mysql/bin/mysql-u root-p
error message ::-bash:mysql:command not found
$ cd/usr/local/bin/
$ sudo ln-fs/usr/local/mysql/bin/mysql mysql
Re-starting MySQL
Mac install MySQL
