社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
https://blog.csdn.net/pansanday/article/details/54915916
安装过程中,记得注意弹窗,有一个会显示密码
参考:https://blog.csdn.net/e421083458/article/details/46789971
1、安装
$ brew install mysql
2、设置开机自启动
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
3、开启服务
mysql.server start
The `brew link` step did not complete successfully
The formula built, but is not symlinked into /usr/local
Could not symlink include/mysql
/usr/local/include is not writable.
You can try again using:
brew link mysql
原因:无法写入 /usr/local/include
文件夹
解决方法:
去 /usr/local/include
看看
我的 /usr/local
下面并没有 include 文件夹,于是我就新建了一个;然后再使用 brew link mysql
,这次报错:
Error: Could not symlink lib/libmysqlclient.20.dylib
/usr/local/lib is not writable.
我的 /usr/local
下面并没有 lib 文件夹,于是我就新建了一个 lib
再次运行 brew link mysql
就成功了。
mysqld_safe A mysqld process already exists
https://blog.csdn.net/xiaozhuanddapang/article/details/53185775
要卸载干净的话,要写在很多地方,否则会影响下一次安装;
比如偏好设置、开机启动设置等,也要卸载哦。
brew remove mysql
brew cleanup
launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist
rm ~/Library/LaunchAgents/com.mysql.mysqld.plist
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /private/var/db/receipts/*mysql*
vim /etc/hostconfig
edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
从 cmd 进入 mysql 命令行模式mysql -uroot -p
输入密码,即可进入
退出mysql>exit;
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_demo0 |
| db_demo1 |
| sys |
+--------------------+
创建数据库 db_demo1mysql>create database db_demo1 charset utf8;
关闭数据库mysql>drop database db_demo1
mysql> use db_demo0; # 进入数据库db_demo0
mysql> show tables;
mysql> desc users;
navicat 是一款 Windows、Mac 都有的数据库查看工具;
破解版下载地址:
https://download.csdn.net/download/meiyoujiaru/10214364
下载成功后,如果报文件损坏,需要设置:安全性与隐私—>允许任何来源。
如果没有 允许任何来源选项,可命令行输入下面命令来解决:
sudo spctl --master-disable
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!