dokku/dokku-mysql

tunneling into mysql:connect

fruitl00p opened this issue · 1 comments

This isn't really an issuer per se as much a documentation issue...

We had some issues trying to get an outside user of the mysql-service to connect and administer their database. After much back-and-forth we finally came to the conclusion that the authorized_keys prohibited the user from building a tunnel using the dokku-user for MySQL...

We still have an issue with remotely connecting to the mysql service using ssh dokku@$host mysql:connect $db which results in a 'black screen'. This black screen seems to be a console prompt (without the console) and after a single query (ie. show tables;) the connection is lost again... Any tips? (this last part is actually an issue)

I'm not sure, maybe it has to do with the tty vs non-tty connection? This is the command we end up running: https://github.com/dokku/dokku-mysql/blob/master/functions#L21