MacOS X install MySQL

Note:

System Version ------ MacOS X 10.6.8

MySQL version ---- the latest official website version 5.5.19

1, from the MySQL official website download installation file from the MySQL official website download Installation File, download entry: http://www.mysql.com/downloads/mirror.php? Id = 404973 # mirrors2. compress the file and install it. decompress the downloaded DMG image file, which contains four files.

Readme.txt Installation instructions

Mysql-5.5.19-osx10.6-x86_64.pkg Database Server (first install it)

MySQL. prefpane system preference settings component, add MySQL to the preference settings panel mysqlstartupitem. PKG boot automatically run 3, add configuration file run the following command to add a configuration file sudo CP/usr/local/MySQL/support-files/my-large.cnf/etc/My. run the following command to change the MySQL password to 111111 playermatomacbook :~ Player $/usr/local/MySQL/bin/MySQL-u rootmysql> Use mysqlmysql> Update user SET Password = PASSWORD ("111111") where user = 'root '; mysql> flush privileges; mysql> quit