phpmyadmin alternative

Red Squirrel

No Lifer
May 24, 2003
69,930
13,457
126
www.anyf.ca
Is there other web based sql management apps out there that are decent? I find phpmyadmin has become bloated, and now they've put too many dependancies (such as mysqli) and it does not even work on all servers out of the box anymore. It used to be a drop in install, but not anymore. It also has other anoyances such as requiring to click all over to expand stuff instead of just having it in front of you right off the bat (such as table details, etc).

Something like this is probably not very hard to code, for basic functionality, but just wondering if there's other php based systems out there that have the same task. Basically I just want an easy way to view/edit databases. User management is a plus.

I can always just use the mysql tool too and connect directly I suppose but web based is always nice.
 

ScottMac

Moderator<br>Networking<br>Elite member
Mar 19, 2001
5,471
2
0
I like NaviCat. I used their free version for a while, then got the $$ version to get the import/export features.
 

heymrdj

Diamond Member
May 28, 2007
3,999
63
91
Originally posted by: ScottMac
I like NaviCat. I used their free version for a while, then got the $$ version to get the import/export features.

I too like it, but that's a client side software, not a server side app. Some servers don't allow external connections to the database system.
 

oburlaca

Junior Member
May 2, 2009
1
0
0
AeroSQL is a free web based tool for managing MySql servers written in PHP. 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. For now, the query browser represents the main functionality. Additional features will be added in the next versions: administration tools (backup, restore), database object management (create tables).

Homepage: http://www.burlaca.com/aerosql/

Demo: http://www.burlaca.com/aerosql-demo/
User: demo
Pass: demo

More screenshots and a video is available at the homepage.

Key Features

  • Multiple servers administration;
    Live Queries: if a SELECT is performed on a single table and the result contains a unique index, AeroSQL will let you update the result set, i.e. the result is not read-only; (The unique index with the mininum number of columns is used. If a table doesn?t have a unique index at all, ALL the columns are used as an index.)
    Sql Monitor: view all SQL commands issued by the server side script;