What is the process to establish a direct connection between DBeaver and MySQL on Kubernetes without relying on kubectl port-forwarding?

edit

To establish a direct connection between DBeaver and MySQL on Kubernetes without relying on kubectl port-forwarding, you can follow these steps:

1. Create a Kubernetes service for the MySQL pod or deployment that you want to connect to. This service should expose port 3306, which is the default MySQL port.

2. Get the hostname and port number of the Kubernetes service that you just created. You can use the following command to get this information:

   kubectl get svc <service-name>
   

   Replace <service-name> with the name of your Kubernetes service.

3. Configure DBeaver to use the hostname and port number of the Kubernetes service to connect to MySQL. You can create a new database connection in DBeaver and use the following settings:

   • Database driver: MySQL
   • Host: <service-host>
   • Port: <service-port>
   • Database: <database-name>
   • User: <database-user>
   • Password: <database-password>

   Replace <service-host> and <service-port> with the hostname and port number of your Kubernetes service. Replace <database-name>, <database-user> and <database-password> with the name, user and password of your MySQL database.

4. Test the connection to MySQL by clicking the "Test connection" button in DBeaver. If the connection is successful, you should be able to see the list of databases and tables in your MySQL database in the DBeaver interface.