Answer the question
In order to leave comments, you need to log in
What to use for remote management of Azure mysql DB?
There is a django project deployed on a virtual machine in Azure with a mysql database.
I manage the database through the putty command line. It works, but I would like to use some kind of visual interface.
There is already a sad experience of working with products for web development from Microsoft, which allow supposedly "in two clicks" to open, install and configure everything with closed eyes. I would like to avoid this if possible. Recommend some tool for remote control of the azure database - for viewing, creating, deleting tables, editing content.
And it's still unclear how to connect to a remote database. Here is the name of the site: sitename.net
In the settings for connecting to the database ' HOST': '/opt/bitnami/mysql/tmp/mysql.sock',
What is the path to the database in the end? sitename.net/opt/bitnami/mysql/tmp/mysql.sock' ?
upd
not quite accurately described the connection string. the second part looks like this:
.../opt/bitnami/mysql/tmp/mysql.sock:3306/djangostack
what's at the beginning?
doesn't work like this:
sitename.net/opt/bitnami/mysql/tmp/mysql.sock:3306/djangostack
Answer the question
In order to leave comments, you need to log in
No and no need
The most visual interface - console
In the database connection settingsto DBMS database
Almost got it with PyCharm.
The connection string looks like this. jdbc:mysql://sitename.net:3306/dbname
But when connecting, I got a driver error "The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."
There is no unequivocal solution: stackoverflow.com/questions/6865538/solving-a-comm...
But I remember that for a long time in a similar situation in advanced connection settings I changed some flags and everything worked. True, then it was a local database.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question