Tell me more ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

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

4 Answers

up vote 2 down vote accepted

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

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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