Connect MySQL to Vagrant

0
200
views

Change Address Binding from MySQL

  • Connect to vagrant using vagrant ssh
  • Edit file /etc/mysql/my.cnf, change parameter bind-address to * to allow all incoming connection attempts
  • Change privileges of the MySQL user to allow connection attempts from any host:On host connect as root user using
    mysql -u root- proot
    mysql > GRANT ALL PRIVILEGES ON *.* TO root@”%” IDENTIFIED BY “root”;

LEAVE A REPLY

Please enter your name here
Please enter your comment!