I’m trying to allow external connection from a One Click Wordpress to a Managed MySQL Database Cluster via VPC Network.
I’ve added bind-address = 0.0.0.0 to /etc/mysql/mysql.conf.d/mysqld.cnf
CREATE USER 'test'@'[VPC NETWORK HOST]' IDENTIFIED WITH mysql_native_password BY 'password';
I’ve added Wordpress Droplet as trusted sources.
But nothing seems to work. The command mysql -u test -p returned ERROR 1045 (28000): Access denied. Am I missing something? What is the best way to manually connect Wordpress Droplets to a Managed Database Cluster?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!