I am studying database systems and using MySQL and phpMyAdmin.

The editor that comes with phpMyAdmin is plain editor that does not highlight any special syntax like for example: gEdit in ubuntu.

Can I change the editor?

closed as off-topic by Zistoloen, dan Feb 26 '14 at 9:58

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking us to recommend a tool, library or favorite off-site resource are off-topic for Pro Webmasters as they tend to attract opinionated answers and spam." – Zistoloen, dan
If this question can be reworded to fit the rules in the help center, please edit the question.


Update your phpMyAdmin. The latest version (3.5) has exactly what you describe.

  • 1
    There's a demo available from their try page where you can see the syntax highlighting. – Su' Jul 16 '12 at 9:39

Maybe some javascript libs (like CodeMirror.net) could add colors to phpMyAdmin editor but I think it's too much work with source code of phpMyAdmin.

It's better and faster to use others application.

For MySQL I use HeidiSQL (windows) or DBeaver (java = windows/linux/mac)


Navicat is a good MySQL editor and management application for windows.


phpMyAdmin is a security hole waiting to happen. I use Navicat over an SSH tunnel. It's a native connection function they have and Navicat works a lot nicer as a complete phpMyAdmin replacement. You're not any longer dependent on a huge and slow php application to do your work. It was one of those programs worth the money I paid for it.

Not the answer you're looking for? Browse other questions tagged or ask your own question.