Can the web project deployed on the Ali CVM connect to the MySQL on the server?

migrate the MySQL database from the local server to the Ali cloud server. The
error deletes the MySQL user and recreates all users with the same username and password as the original user.
Log in to Ali CVM, and you can log in to MySQL users and execute instructions normally on the command line.
run the web project on your local computer and connect to the MySQL database on Ali CVM. connection failed .
connection database code:

:

MySQL3306

clipboard.png

netstat -ntpl | grep 3306,:


MySQL:

clipboard.png

could you tell me how to solve this situation?


is it a problem of SSL


access to the server directly uses the reserved address of 127.0.0.1, and the internal / external network ip of the server that does not need to be called does not need to be opened.
in addition, you can find a database to view the software and connect directly to the database to see if there is anything wrong with the configuration. Personally, it is recommended to use SSH tunnel directly (equivalent to using SSH connection to proxy, so that the firewall does not have to open 3306, your SSH is more secure if you connect with a key).

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b37319-4d711.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b37319-4d711.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?