Setup MySQL Workbench to avoid port clashing with the host system

Edit on GitHub

We recommend setting up TCP/IP over SSH for MySQL to avoid port clashing with the host system. For current connection values have a look at config/Shared/config_default-development_DE.php. Use $HOME/.vagrant.d/insecure_private_key as SSH Key File.

MySQL: Workbench vagrant setup

In case the connection fails, run the following command :

CREATE USER 'root'@'%' IDENTIFIED BY ''; # no password will be set
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%';
FLUSH PRIVILEGES;

This command creates a new root user with full permissions.