For a purely programmatic solution, I'd recommend the Oracle provided Python-MySQL Connector. It is GPL licensed or you can purchase a different license as well. I have only used it a bit so I can't comment on ease of use for advanced functionality but simple queries work fine and fast.
I have read about a Python/MySQL GUI - although it does appear to be somewhat focused on plotting it does state that it supports creation and management (as well as analysis). Despite not having (yet) tried it from what I've read it looks quite good - and since it is open source and python if it is something close you can relatively easily extend it to do what you need.
You can use MySQL Workbench:
- works on Windows/Linux/Mac
- straightforward to install (
- it's a desktop application, not a web interface. No need for PHP.
- syntax highlighting
- auto completion
- SQL documentation on the side
- in addition to the SQL Editor, you can design visually database (usual EER) and administer the database.
Visual Database Design:
An interface is a rather broad term, but if you are looking to manage your SQL databases with a GUI, SQuirreL is the most powerful and versatile option. It's not pretty, but once it's set up, it's one of the best tools out there.
I have used it for Oracle, Microsoft, MySQL and PostgreSQL databases with no issues.
It's a Java application, so it doesn't require GTK or anything else for that matter, and it will work on all platforms.
Alternatively, you can simply use
psql commands from the command line over SSH. That's as simple as it gets, provided that you don't mind opening a terminal.
I'm developing a database explorer with a focus on breadth, not depth. It is written in Python 2, which is likely already installed on your server.
Right now it won't let you run arbitrary queries , but that is high on the feature list. Squeal now supports running arbitrary SQL queries!
Note that the application is in a very early stage of development. Depending on your perspective, that is good or bad. It likely does not yet support all the features that you need, but I am a very responsive developer and I'll add the features as you need them.
I can recommend Database Workbench - although it's a Window based tool, it works fine under Wine and is used by many users like that.
It includes design, debugging, management, migration and database browsing and editing tools.