Homestead 下 mariadb 总是自动断开连接?
Homestead下开发项目,浏览器访问时时不时就会提示“SQL拒绝连接“
SQLSTATE[HY000] [2002] Connection refused
Navicat访问时提示:
Lost connection to MySQL server at 'reading initial communication packet', system error: 0 "Internal error/check (Not system error)"
这是我的Homestead配置:
---
ip: "192.168.10.10"
memory: 2048
cpus: 1
provider: virtualbox
mariadb: true
authorize: ~/.ssh/id_rsa.pub
keys:
- ~/.ssh/id_rsa
folders:
- map: ~/Codes/php
to: /home/vagrant/Code
sites:
- map: task.local.com
to: /home/vagrant/Code/task/public
- map: laravel.local.com
to: /home/vagrant/Code/laravel/public
databases:
- homestead
# blackfire:
# - id: foo
# token: bar
# client-id: foo
# client-token: bar
# ports:
# - send: 50000
# to: 5000
# - send: 7777
# to: 777
# protocol: udp
项目数据库连接配置:
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=task
DB_USERNAME=homestead
DB_PASSWORD=secret
开发环境:
机器:MacBook Pro (Retina, 13-inch, Mid 2014)
操作系统:MacOS Sierra 10.12.3 (16D32)
MariaDB:10.2.4
Homestead版本:2.0.0
Vagrant 版本:1.9.2
IDE:sublime text 3 和 PhpStorm 2016.3
现在基本上已经到了一分钟左右就自动断开的地步,开发时总是需要不停的去Homestead里面启动MariaDB,各位大神,有谁知道是什么原因吗?
可能是虚拟机启动过程中出现了错误,移除虚拟机重新创建后,尚未发现此问题。