sudo gedit /etc/mysql/my.cnf
bind-address = 0.0.0.0
mysql -u root -p
GRANT ALL ON *.* TO root@'*' IDENTIFIED BY 'mypasswd'; quit
sudo service mysql restart
bzw.
sudo systemctl restart mysql.service
Hört MySQL zu?
sudo netstat -anp | grep :3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 9904/mysqld
OK, dann von dem Wirts-System:
mysql -u root -p -h 192.168.146.130 Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.146.130' (113)
🙁