14

Is there any webbased interface for MySQL better than phpMyAdmin? I use phpMyAdmin a lot but it is becoming a pain, especially it is slow sometimes.

I'd like to have deep export functionality like phpMyAdmin but more design features

Mark
  • 10,754
  • 20
  • 60
  • 81

11 Answers11

6

Why don't you just use a client? They are a lot nicer in my opinion.

I love SQLyog because it supports a lot of MySQL features (stored procedures) but I used to use HeidiSQL and it was nice as well.

As for web based clients, I haven't got any suggestions unfortunately.

Joe Phillips
  • 49,743
  • 32
  • 103
  • 159
4

Try DBlite. It's has got a nice intuitive interface and gets the work done faster and with fewer clicks than in phpmyadmin.

Rajiv
  • 2,352
  • 1
  • 22
  • 25
2

try checking these out http://www.webresourcesdepot.com/category/goodies/database/

as a client, I recommend EMS Manager, as well as for Posgtres

zalew
  • 10,171
  • 3
  • 29
  • 32
2

I know about SqlBuddy. It has a simpler interface that phpMyAdmin - but pma is much more powerful.

There is also the VFront application. I have not tried it yet - so I cannot comment on it.

Binny V A
  • 2,036
  • 3
  • 20
  • 23
2

As clients, the MySQL Query browser and Administrator are quite good. That has a number of different export facilities that are cool. If it needs to be web though, then you might be best sticking with the slow phpmyadmin.

Amadiere
  • 11,313
  • 6
  • 41
  • 47
2

Among non-web clients, I use Navicat for MySQL. The free version can do everything phpMyAdmin can

Imran
  • 87,203
  • 23
  • 98
  • 131
  • I can't find a free version download in there website there is only a trial version – Youssef Bouhjira Jan 20 '14 at 01:37
  • 2
    Unfortunately they discontinued the free versions. You can still get the last free version someplace else: http://download.cnet.com/Navicat-Lite-for-MySQL/3000-10254_4-10908646.html – Imran Jan 20 '14 at 05:51
1

http://www.webdesigneronline.co.uk/10-great-alternatives-to-phpmyadmin

It lists several on here but also lists a few not mentioned like

Adminer

I started using Adminer as it comes with free skins and scripts and mods - best of all, it one PHP file that sits on the server, so you can even call it "private_32492834234.php"

TheBlackBenzKid
  • 26,324
  • 41
  • 139
  • 209
0

I suggest phpadminer because it is lightweight and has only one php file, but you should continue with slow phpmyadmin.

Shahnawaz Khan
  • 99
  • 1
  • 3
0

Actualy im using mywebsql and im very happy with it. You should check it out.

thclpr
  • 5,778
  • 10
  • 54
  • 87
0

as a client I recommend Toad For Mysql (it is free)

Sulaiman
  • 496
  • 2
  • 10
  • 19
0

I'd like to suggest AeroSQL, it's an open source (GPL) web based MySql Manager built using PHP and ExtJS library.

There is a demo, video and screenshots available.

Project homepage: http://www.burlaca.com/aerosql/

The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications. The grid is editable: you can update cells and save the changes to the backend database server.