Remote connect Mysql / MariaDB:
Solution:
1. mysql -u root -p
Input YSQL ROOT pass
2. Enable remote connect
grant all privileges on *.* to ‘root’@’%’ identified by ‘your ROOT pass’ with grant option;
3. Disable remote connection
grant all privileges on *.* to ‘root’@’127.0.0.1’ identified by ‘passwd’ with grant option;
4. Port 3306 must open to remote and you need restart Mysql service.
END