Mysql deploy on micro, problem with connection to DB

Troubleshooting and help
1

Hello, I deploy msql:latest on micro where daploy is healthy but I can’ connect via mysqlworkbench. Password is set, ports set on 3306/tcp.
Runtime logs show that server is shutdown.
Is somebody use mysql working correctly on koyeb platform?
Could somebody help how to fix my problem?

Regards rzi
below runtime logs:

2022-11-21 19:27:00+00:00 [Note] [Entrypoint]: Temporary server stopped

instance-a2f236ee

stdout



instance-a2f236ee

stdout

2022-11-21 19:27:00+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

instance-a2f236ee

stdout



instance-a2f236ee

stderr

2022-11-21T19:27:00.601330Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.

instance-a2f236ee

stderr

2022-11-21T19:27:00.604961Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1

instance-a2f236ee

stderr

2022-11-21T19:27:00.615942Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

instance-a2f236ee

stderr

2022-11-21T19:27:00.863487Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

instance-a2f236ee

stderr

2022-11-21T19:27:01.122405Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

instance-a2f236ee

stderr

2022-11-21T19:27:01.122578Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

instance-a2f236ee

stderr

2022-11-21T19:27:01.123378Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.

instance-a2f236ee

stderr

2022-11-21T19:27:01.143550Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock

instance-a2f236ee

stderr

2022-11-21T19:27:01.143870Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.31' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.

instance-1bd798f7

stderr

2022-11-21T19:27:29.325466Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.31).

instance-1bd798f7

stderr

2022-11-21T19:27:30.007819Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.31) MySQL Community Server - GPL.
2

Dear admins & community, is this forum still alive? somebady who knows better than me can help with deploing mysql on Koyeb platform?
regards rzi

3

Hey Rzi :wave:

If I am correct, it looks like you’re trying to connect your database from the Internet. Currently, we don’t support public inbound TCP connections. You can vote and track this feature’s progress here: Support public inbound TCP connections | Voters | Koyeb

That being said, you can deploy a development database on Koyeb and access it from another service using the Service Mesh. Note that Koyeb storage is stateless, meaning your data could be lost and you should only run this database for development purposes.

Otherwise, another solution we recommend is using a managed MySQL database provider. We list a few suggestions in Which Cloud Database Platform to Choose for Your Applications - Koyeb.

Last thing, others have requested the platform to offer Managed MySQL | Voters | Koyeb. This is something we want to do in the future.