Do I need to enable Remote Database Access?

2019-08-26 10:50发布

问题:

I'm building an application which automatically updates an online MySQL database with results from a local computer.

I plan to run the following command

C:>mysqldump -uUSER -pPASSWORD DATABASE > database.sql
C:>mysql -hHOST -pPORT -uUSER -pPASSWORD DATABASE < database.sql

Would doing this require me to add my IP address to the Remote Database Access Hosts section of my cpanel?

回答1:

you need to enable remote access to your mysql database server:enable remote access