Thank you for your great work. I tried to allow remote connectin to the DB for root, because I like to use MySQL clients like HeidiSQL during local development.
I set
default['mariadb']['forbid_remote_root'] = false
default['mariadb']['mysqld']['bind_address'] = '0.0.0.0'
in berks-cookbooks/mariadb/attributes/default.rb, but unsuccessfully.
After vagrant provision I had to set bind_address manually, create MySQL user, set permissions
CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'root'
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; FLUSH PRIVILEGES;
and remote connection works well.
Can you tell me what is the right way to enable remote access to DB?
Thank you for your great work. I tried to allow remote connectin to the DB for root, because I like to use MySQL clients like HeidiSQL during local development.
I set
default['mariadb']['forbid_remote_root'] = falsedefault['mariadb']['mysqld']['bind_address'] = '0.0.0.0'in berks-cookbooks/mariadb/attributes/default.rb, but unsuccessfully.
After vagrant provision I had to set bind_address manually, create MySQL user, set permissions
CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'root'GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; FLUSH PRIVILEGES;and remote connection works well.
Can you tell me what is the right way to enable remote access to DB?