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?

Data-Migration Server linux mysql
Mar.03,2022

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).

Previous: This pointing to the problem

Next: The processing of the result value returned by javascript asynchronously

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
© 2021 CodesHelper
Advertising Contact us About us
Menu