Keywords: LAMP/MAMP/WAMP - AWS - Technical issue - Connectivity (SSH/FTP)
bnsupport ID: 03ff14f6-442c-dd46-fdcf-a8a6989f2ae7
I have an Amazon Lightsail instance running Bitnami LAMP. I'm trying to connect to MySQL remotely in order to use a database as a data source in Google Data Studio.
This is what I've tried so far:
I commented out the bind-address=127.0.0.1 line in /opt/bitnami/mysql/my.cnf, I restarted mysql, I opened the port 3306 from the Lightsail console, I created a remote user:
CREATE USER 'teleuser'@'%' IDENTIFIED BY 'monkey123';
GRANT ALL ON *.* TO 'teleuser'@'%';
When I try to connect from Data Studio I get this error:
"Sorry, we encountered an error and were unable to complete your request. Error ID: 4dcecaae"
I tried to connect using the terminal from another server,
mysql -u teleuser -h IP_ADDRESS -p but I get this error:
ERROR 2003 (HY000): Can't connect to MySQL server on 'IP_ADDRESS' (111 "Connection refused")
When using SequelPro the connection is established but as soon as I select a database there's an unexpected error and the program exits.