Several pits on Mac OS X Yosemite installed on MYSQL 5.6.26

Pit 1, default port not 3306

A "MYSQL" control Panel will be added to "System Preferences" after installation with MYSQL-5.6.26-OSX10.9-X86_64.DMG

But the port that started MySQL server might be 3307 not the default 3306, if you want to use 3306 you need to modify the configuration file/library/launchdaemons/com.oracle.oss.mysql.mysqld.plist

<string>--port=3307</string>

Switch

<string>--port=3306</string>

Pit 2, Default user root No password, client cannot connect MySQL

shell> mysql-u root mysqlmysql> UPDATE mysql.user SET Password = Password (' newpwd ') WHERE user = ' root ';mysql> F LUSH privileges;

Pit 3, the client may still not be connected

Need to configure TCP/IP connection pipeline

sudo mkdir/var/mysqlsudo ln-s/tmp/mysql.sock/var/mysql/mysql.sock

TIPS

To facilitate the execution of MySQL command line, you also need to configure the environment variables, modify the Bash_profile

Nano ~/.bash_profile

Export path= "/usr/local/mysql/bin: $PATH"

SOURCE ~/.bash_profile

Several pits on Mac OS X Yosemite installed on MYSQL 5.6.26