Webmasters Stack Exchange is a question and answer site for pro webmasters. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

up vote 3 down vote accepted

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

share|improve this answer
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)

share|improve this answer
+1 for HeidiSQL – John Conde Jun 17 '12 at 19:45

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

share|improve this answer

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.

share|improve this answer

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