Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Manually Connecting One Click Wordpress to Managed MySQL Database
I’m trying to allow external connection from a One Click Wordpress to a Managed MySQL Database Cluster via VPC Network.
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';
Managed Database Cluster
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.×