MySQL是最流行的开源数据库，而PostgreSQL是最先进的开源数据库。虽然我现在自己已经全面投入PostgreSQL的怀抱中了，但是还有许多迷途的羔羊执迷不悟，或者无力抽身，不求上进，满足于MySQL。所以目前来看还有是有MySQL的使用需求的。本文描述了*nix下MySQL的源码安装方法。

从源码编译安装MySQL

1. tar -zxvf mysql-5.7.9-osx10.10-x86_64.tar.gz
2. mv mysql-5.7.9-osx10.10-x86_64 /usr/local/mysql
3. chown -R root:wheel mysql
4. bin/mysqld --initialize --user=mysql
5. cd /usr/local
6. sudo chown -R root:wheel mysql
7. cd /usr/local/mysql
8. sudo bin/mysqld --initialize --user=mysql
10. # Remember the root password
11. cp support-files/my-default.cnf /etc/my.cnf
13. # Add Following content to /etc/my.cnf
14. [client]
15. default-character-set=utf8
16. [mysqld]
17. default-storage-engine=INNODB
18. character-set-server=utf8
19. collation-server=utf8_general_ci
21. # Admin
22. support-files/mysql.server start
23. support-files/mysql.server restart
24. support-files/mysql.server stop
25. support-files/mysql.server status
27. # Change Root Password
28. bin/mysqladmin -u root -p password <newpassword>
29. $ <Input temp password here>
31. # login with root
32. bin/mysql -p
34. # Create Main User
35. CREATE USER 'vonng'@'%' IDENTIFIED BY 'xxxx';
36. grant all privileges on *.* to 'vonng'@'%' with grant option;
37. create database vonng;
38. create database test;
40. # Create server user
41. CREATE USER 'vonngserver'@'localhost' IDENTIFIED BY 'xxxx';
42. grant all privileges on vonng.* to 'vonngserver'@'localhost';
43. grant all privileges on test.* to 'vonngserver'@'localhost';
44. flush privileges;
46. # Uninstall
47. sudo rm -rf /usr/local/mysql
48. sudo rm -rf /usr/local/mysql*
49. sudo rm -rf /Library/StartupItems/MySQLCOM
50. sudo rm -rf /Library/PreferencePanes/My*
51. sudo rm -rf /Library/Receipts/mysql*
52. sudo rm -rf /Library/Receipts/MySQL*
53. sudo rm -rf /var/db/receipts/com.mysql.*
55. # Dump:
56. /path/to/mysql/bin/mysqldump -u<username> -p <databasename> > dumpfile_name
57. # Example: /usr/local/mysql/bin/mysqldump -uvonng -p cnzzdb > ~/Data/mysql/cnzzdb.sql
59. # Recover
60. mysql -u<username> -p -D <dbname> < dump_file_name
61. # Example mysql -p -D testdb< ~/Data/mysql/cnzzdb.sql

在Mac上设置开机自动启动

1. sudo vi /Library/LaunchDaemons/com.mysql.mysql.plist
3. <?xml version="1.0" encoding="UTF-8"?>
4. <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
5. <plist version="1.0">
6. <dict>
7. <key>KeepAlive</key>
8. <true/>
9. <key>Label</key>
10. <string>com.mysql.mysqld</string>
11. <key>ProgramArguments</key>
12. <array>
13. <string>/usr/local/mysql/bin/mysqld_safe</string>
14. <string>--user=root</string>
15. </array>
16. </dict>
17. </plist>
19. sudo launchctl load -w /Library/LaunchDaemons/com.mysql.mysql.plist