Hi everyone, I’m fairly new to both Aiven and MySQL, so this question may not be very detailed or technically correct (in which case, please correct me as I’m trying to learn!)
In any case, my Aiven MySQL instance has a status of “Running”, and when I try to connect with it using the MySQL shell and the provided code from “Quick Connect”, I get the following error:
ERROR: Not connected.
Why is this happening? How can I gather more info on the error?
The allow list can be seen on the home page of your service in the Aiven console. By default it’s open though, so I think the issue is probably on your server.
Verify Connection Details: Double-check the connection details such as hostname, port, username, and password. Ensure they are correctly entered into the MySQL shell command.
Firewall Settings: Make sure that your firewall settings allow connections to the MySQL instance. Sometimes, firewalls can block incoming connections.
Network Issues: Ensure that there are no network issues preventing the connection. You can try pinging the Aiven MySQL instance to check if it’s reachable from your machine.
SSL Configuration (Optional): If SSL is enabled on your Aiven MySQL instance, ensure that your MySQL client is configured to use SSL accordingly.
Aiven Service Status: Check the status of your Aiven MySQL service in the Aiven dashboard. If there are any ongoing maintenance activities or issues, they might affect connectivity.
Review Logs: Look into the logs of your Aiven MySQL instance. They might provide more detailed error messages that can help diagnose the issue.
@Matt_Cornillon sorry for the late reply. If I understand your question correctly, I have tried using terminal, MySQL Shell, MySQL Command Line Client, and also MySQL Workbench. The MySQL Workbench actually worked, but I’d rather work with the command line.
@Danishhafeez considering I’m able to connect via the MySQL Workbench, I don’t think there are any issues with connecting via the points you’ve provided