安装
方法一:
1.到MySQL官网下载MySQL Community版,(作者下载的是mysql-5.6.21)MySQL分为商业版(Enterprise)和社区版(Community),商业版是要收费的,社区版是免费的。
MySQL的Mac版安装包分为两种一种是DMG Archive,另一种是Compressed Tar。DMG的安装比较简单,只需要双击安装文件即可,Compressed Tar的安装请自行查找资料。
2.mysql的安装路径为:
同时,MySQL会在/usr/local/mysql创建一个指向该文件夹的软链接(symbolic link),
方法二:
利用homebrew进行安装。
brew install mysql
安装路径位于
启动MySQL
启动:
/usr/local/Cellar/mysql/5.6.21/bin/mysql.server start
重启:
/usr/local/Cellar/mysql/5.6.21/bin/mysql.server restart
关闭:
/usr/local/Cellar/mysql/5.6.21/bin/mysql.server stop
使用MySQL
1. 为root创建密码
mysqladmin -u root password "root" //初始化密码, 第二个root为密码
2. 修改root密码
mysqladmin -u root -p password "admin"
3. 进入MySQL
mysql -u root -p
4. 然后就可以执行MySQL命令了,千万记得每条命令要以;结尾。
show databases;
5.创建新用户
INSERT INTO User (Host, User, Password, ssl_cipher, x509_issuer, x509_subject) VALUES ('localhost', 'sloth', Password('sloth'), '', '', '');
6. 退出mysql
exit
删除MySQL
1 sudo rm /usr/local/mysql
2 sudo rm -rf /usr/local/mysql*
3 sudo rm -rf /Library/StartupItems/MySQLCOM
4 sudo rm -rf /Library/PreferencePanes/My*
5 vim /etc/hostconfig (and removed the line MYSQLCOM=-YES-)
6 rm -rf ~/Library/PreferencePanes/My*
7 sudo rm -rf /Library/Receipts/mysql*
8 sudo rm -rf /Library/Receipts/MySQL*
9 sudo rm -rf /var/db/receipts/com.mysql.*