This page is about how to set up mariadb, mysql 10.0 remote server with btpanel 宝塔面板 or aapanel.
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
A server with btpanel installed
Open the app store, search for "mysql" and install maria db 10.0+
(Optional) install php and phpmyadmin for easier db access. if you do so, open port 888 in ALL security groups.
OPEN PORT 3306 for ALL firewalls the server binds to. This could be the one that comes from the internet service provider.
Note: You MUST manually open 3306 on bt-panel security group!
Copy this code and append into the configuration file of mysql.
[mysqld]
skip-networking=0
skip-bind-address
Restart MySQL service. Reconnect on local.
Open the app store, search for "mysql" and install maria db 10.0+
2. (Optional) install php and phpmyadmin for easier db access. if you do so, open port 888 in ALL security groups.
OPEN PORT 3306 for ALL firewalls the server binds to. This could be the one that comes from the internet service provider.
Note: You MUST manually open 3306 on bt-panel security group!
Copy this code and append into the configuration file of mysql.
[mysqld]
skip-networking=0
skip-bind-address
Restart MySQL service. Reconnect on local.