P
P
pvgdrk2015-07-02 11:19:11
MySQL
pvgdrk, 2015-07-02 11:19:11

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

2 answer(s)
S
sim3x, 2015-07-02
@sim3x

No and no need
The most visual interface - console

In the database connection settings
to DBMS database
name in "NAME"

P
pvgdrk, 2015-07-02
@pvgdrk

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 question

Ask a Question

731 491 924 answers to any question