There are many MySQL Clients(or database administration tools) out there - MySQL Front End, Tora, mysql etc. But in the web environment, one client rules - phpMyAdmin. phpMyAdmin is a PHP based(obviously) GUI administration tool for MySQL.
When I began programming in Linux, I could not use the DB Administration tool my co-workers were using. They were using MySQL Front End - and only the windows version was available for it. Since no one in my office used Linux, none knew another DBA for Linux. One suggested Tora, but I could not get it to run - some dependencies were missing. Anyway, I was forced to use mysql - yes, the command line client that came with MySQL Server. You can start it by bringing up a terminal and entering 'mysql' into it. Then you type every SQL command you want to execute into it. Trust me, it was not fun. The biggest problems was that I want to copy something and press 'Ctrl+C' - in the terminal 'Ctrl+C' is not Copy - its Close. So the client goes down. It was very irritating. Anyway I found phpMyAdmin before long and have been using it ever since(even after I got Tora running).
The biggest advantages of phpMyAdmin is that it is web based - it runs on any server capable of handling PHP. Because of this all the online Database Administration is done using phpMyAdmin. If you have a site of your own, and you have the control panel access to it, you will know what I mean. They database management part will be handled by phpMyAdmin. The phpMyAdmin site cites the following as the features of phpMyAdmin...
- Browse, view and drop databases, tables, views, fields and indexes.
- Create, copy, drop, rename and alter databases, tables, fields and indexes.
- Maintenance server, databases and tables, with proposals on server configuration.
- Execute, edit and bookmark any SQL-statement, even batch-queries.
- Create and read dumps of tables - in various formats like CSV, SQL, etc.
- Export data to various formats: CSV, SQL, XML, Excel and more.
- Administer multiple servers.
- Manage MySQL users and privileges.
- Check referential integrity in MyISAM tables.
- Using Query-by-example (QBE), create complex queries automatically connecting required tables.
- Search globally in a database or a subset of it.
- Support InnoDB tables and foreign keys.
- Support mysqli, the improved MySQL extension.
- And more...
phpMyAdmin is so commonly used that there is a book - Mastering phpMyAdmin for effective MySQL Management - that aims to teach it.
Reference
- phpMyAdmin Project Documentation
- Learning SQL Using phpMyAdmin
- Doing More With phpMyAdmin - A 7 part tutorial for configuring and using phpMyAdmin.
1 Comment:
hi all, i was amazed after knowing that sqlyog is an amazing db administartion tool.I must tell you this guys have awesome powertools with cool & amazing features.
Post a Comment