Doing More With phpMyAdmin (Part 1)

Grok Headline matches for Doing More With phpMyAdmin (Part 1)

Doing More with phpMyAdmin (Part 2)

Doing More with phpMyAdmin (Part 2) 12/08/2003 11:46 AM
In the first segment of this two-part tutorial, I gave you a quick overview of some of the interesting new features available in phpMyAdmin. In this concluding segment, find out how to use phpMyAdmin to define relationships between tables, maintain a log of commonly-used queries and create entity-relationship diagrams.

DevShed: Doing More With phpMyAdmin
(Part 1)

DevShed: Doing More With phpMyAdmin
(Part 1) 10/28/2003 11:07 PM
If you've ever had a shared hosting environment and had to deal with the frustration of not being able to access the command line, then you know the joy that phpMyAdmin can bring. Now, DevShed is looking to share the love with thier latest posting.

DevShed: Working with phpMyAdmin (Part
2)

DevShed: Working with phpMyAdmin (Part
2) 12/09/2003 08:28 AM
In Devshed's latest article, Doing More with phpMyAdmin (Part 2), they continue where they left off in this piece continuing your education on how to use this powerful tool.

Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 1

Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 1 09/16/2002 01:36 AM
This two-part tutorial covers nearly every detail of one writer's quest to install and configure a Web server, server-side scripting language, database, and data administration application on Windows 2000. Part 1 focuses on how to get Apache 1.3.26 with Mod_SSL 2.8.10 and PHP 4.2.2 up and running.

Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 2

Real-World Windows 2000 Configuration:
Getting Apache, PHP, MySQL, and
phpMyAdmin to Work Together, Part 2 09/16/2002 01:36 AM
This two-part tutorial covers nearly every detail of one writer's quest to install and configure a Web server, server-side scripting language, database, and data administration application on Windows 2000. Part 2 examines ways to install and configure MySQL and phpMyAdmin on the operating system.

phpMyAdmin - Mysql DB administration
tool - www.phpmyadmin.net

phpMyAdmin - Mysql DB administration
tool - www.phpmyadmin.net 02/06/2005 03:07 AM
phpMyAdmin - Mysql DB administration tool - www.phpmyadmin.net .. released a new version .. phpMyAdmin 2.3.2 .. phpMyAdmin .. 2.4.0-rc2

phpmyadmin.net
track this site | 3 links

phpMyAdmin 2.3.2

phpMyAdmin 2.3.2 10/31/2002 01:15 AM
After over a year of development, the new version of phpMyAdmin (which allows you to manage your mysql databases from a web server)was released this month.

I just downloaded it today. After 10 minutes of testing, my opinion is that it is a step backward. In previous versions, i could enter SQL from nearly every important screen in phpMyAdmin. Now I have to click on a database, then select the SQL tab. Secondly, they have now highlighted the DROP command in red. After selecting a couple of test tables that I had just created, I clicked on DROP to remove the test tables, only to find to my horror that it was DROP DATABASE!

This just reinforces my opinion that good user interface designers are too well paid to contribute to Open Source projects :-)

"zeldman.lod"

phpMyAdmin

phpMyAdmin 12/07/2003 04:08 PM
phpMyAdmin 2.5.5-rc1 is released!

phpMyAdmin 2.5.7

phpMyAdmin 2.5.7 06/09/2004 09:16 AM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.5

phpMyAdmin 2.5.5 12/28/2003 04:20 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.4 is released!

phpMyAdmin 2.5.4 is released! 10/29/2003 12:10 AM
The development team is proud to announce the availability of this version, with over 12 improvements and 20 bug fixes. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.6.0-rc1 (Development)

phpMyAdmin 2.6.0-rc1 (Development) 08/09/2004 02:38 AM
Handles the basic adminstration of MySQL over the WWW

Mastering phpMyAdmin

Mastering phpMyAdmin 06/03/2004 07:01 AM

phpMyAdmin is usually installed quickly, out of acute necessity. You need to do something with your database, and you can't do it via telnet or SSH or anything else, so you download the latest version, FTP it up, and away you go. More often than not, the install is forgotten about as soon as your need is over.

The downside of this is that you're not getting nearly the value you should out of a phpMyAdmin install. Most people work with phpMyAdmin superficially and in very narrow usage corridors — like kids walking barefoot on a painted line through a very large parking lot. There's so much about the app that you don't know.

Enter this book: "Mastering phpMyAdmin for Effective MySQL Management." This is the first book I know of solely on phpMyAdmin (though a lot of MySQL books cover it briefly in an appendix or something). It was released by Packt Publishing a few weeks ago.

It's a departure from a lot of tech books in that (1) it's short and sweet (just under 200 pages — not nearly the 600-page monolith some of these things become), and (2) it seems more...conversational. Concepts are explained in plain English. I normally hate that cliche, but it fits here. I got a sense of simply having a casual conversation with a fellow geek.

I read it over the course of a week, putting in a chapter or two each night. I learned something new in every chapter, and I'd implement them in my phpMyAdmin install right after reading the chapter. By the end of the book, I'm left with a superb phpMyAdmin install that does a thousand times more than I've ever accomplished with the app before.

There's a lot of phpMyAdmin functionality under the hood that you've likely never seen. For instance, you can set it up to enforce relational integrity in your database. This is just good database design, but it also enriches the interface considerably. Foreign key fields now become drop-down lists to the foreign table with a selection of entries. You can print a PDF summary document with descriptions of all tables and columns and an entity relationship diagram showing field relationships. Bet you haven't seen that trick before.

I suddenly have a sense of liberation with phpMyAdmin. We all hate writing admin interfaces, especially for one-off apps we do in a hurry. Thankfully, phpMyAdmin can support an enormous amount of administration chores in an interface not nearly as utilitarian as the default one you get on install. It won't work for administering the data of every app you right, but I bet it will handle a lot of them.

I can now see writing apps and doing things that I stayed away from before just because I didn't want to write all the data entry and database admin scripts that easily dominate the work required to put these things together. Instead, I can concentrate on the fun of the front-end pages, while phpMyAdmin sucks up all the back-end work.

The book also includes some good information about PHP and MySQL in general. On page 86, in the chapter on importing data, there's a solid little discussion about PHP file upload and execution limits that trumps anything I've read before. I'm a better developer for having read these four paragraphs about the "upload_max_filesize," "memory_limit," and "post_max_filesize" parameters.

As for MySQL, did you know about InnoDB tables? This is a table format that builds referential integrity into MySQL — something the database has been missing for so long. I'll admit to being utterly ignorant about this feature until this point.

There's a chapter at the end of the book about MIME-based transformations that summarizes the general level of apathy about this app. I can't believe I haven't run across a discussion about this feature before —

You may have known on the periphery that you could store files directly into a MySQL database using a BLOB column. But did you know that phpMyAdmin will support this with a file upload field in the interface, so your users can upload files directly? Or that you can sent a MIME Transformation on that field to display a thumbnailed view of stored images in the row when browsing the database? And that you can link that thumbnail to the full-size version or the image, pulled directly from the field? I'll bet the percentage of phpMyAdmin users who know that trick is in the single digits.

So, good book. If you find yourself writing a lot of throwaway admin interfaces and hating every minute of it, the $30 cover price for this text is probably looking mighty attractive right now.

Click here to comment on this entry

phpMyAdmin 2.6.0-rc2 (Development)

phpMyAdmin 2.6.0-rc2 (Development) 09/06/2004 11:14 AM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.6.0-rc2 is released

phpMyAdmin 2.6.0-rc2 is released 09/07/2004 07:57 PM
Here is the second release candidate for version 2.6.0. Thinks are going well, version 2.6.0-rc1 was tested a lot (with more than 45700 downloads). phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

On the 7th Day God Created phpMyAdmin

On the 7th Day God Created phpMyAdmin 12/10/2002 01:40 AM
phpMyAdmin is by far the most widely used and distributed

phpMyAdmin 2.5.5-rc1 (Development)

phpMyAdmin 2.5.5-rc1 (Development) 12/08/2003 04:42 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.5-pl1 is released

phpMyAdmin 2.5.5-pl1 is released 01/05/2004 08:00 PM
This is the patch level 1 release for 2.5.5, fixing a few problems. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

PHPMyAdmin Book

PHPMyAdmin Book 05/20/2004 02:26 PM

Packt Book Store :: Mastering phpMyAdmin for Effective MySQL Management: We've talked about Packt Publishing befor e, but now it looks like they're really hitting high gear. Here's a book about PHPMyAdmin, which I never thought we'd see but which is badly needed. You may think you know PHPMyAdmin, but if you look under the hood, there's functionality there that I bet you never knew existed.

They also have a book about eZ Publish, which I've worked with and enjoyed very much.

Click here to comment on this entry

phpMyAdmin 2.6.0-beta2

phpMyAdmin 2.6.0-beta2 06/28/2004 06:07 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.6 is released

phpMyAdmin 2.5.6 is released 03/06/2004 02:00 AM
Welcome to this new version, aimed at stabilization of the 2.5 branch. Meanwhile, work is continuing on the new 2.6 branch. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.4.0-rc2 released

phpMyAdmin 2.4.0-rc2 released 02/17/2003 12:15 PM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields. The test cycle is going well, rc2 contains other fixes, and more polishing of the new privileges and database management pages.

phpMyAdmin 2.4.0 released

phpMyAdmin 2.4.0 released 02/24/2003 07:04 AM
The development team of phpMyAdmin is proud to present you the latest version, with a new interface for server administrators, and lots of improvements and fixes. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin-2.5.5-rc2 is released!

phpMyAdmin-2.5.5-rc2 is released! 12/16/2003 07:39 PM
This is the second release candidate for 2.5.5. A few problems were discovered and fixed from 2.5.5-rc1. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

phpMyAdmin 2.3.0 is released

phpMyAdmin 2.3.0 is released 08/12/2002 01:39 AM
You are welcome to use this new stable version, with lots of new features. Details available at http://phpmyadmin.net.

phpMyAdmin 2.5.5-rc2 (Development)

phpMyAdmin 2.5.5-rc2 (Development) 12/15/2003 11:46 AM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.5.7 is released

phpMyAdmin 2.5.7 is released 06/11/2004 07:06 PM
The main reason of this release is to add support for MySQL 4.1.2 in a stable version. It includes also some bug fixes. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

Web Services (XML-RPC) and phpMyAdmin

Web Services (XML-RPC) and phpMyAdmin 07/17/2002 09:05 AM

Installing phpMyAdmin on Linux

Installing phpMyAdmin on Linux 02/10/2004 08:04 PM
GeekSpeek tells us how to set up phpMyAdmin on Linux."Some of its current capabilities include the ability to create and drop databases, create , drop, and alter tables, execute SQL statements, delete, edit, and add fields, manage keys on fields, and manage privileges. In addition, it has the ability to export your data in a number of different formats. phpMyAdmin is an excellent tool and will make the life of any MySQL database administrator much more enjoyable. "

phpMyAdmin 2.6.2-rc1 (Development
branch)

phpMyAdmin 2.6.2-rc1 (Development
branch) 04/03/2005 09:24 PM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.

phpMyAdmin 2.3.0-rc2 (Unstable) released

phpMyAdmin 2.3.0-rc2 (Unstable) released 07/03/2002 01:14 PM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.

phpMyAdmin 2.6.0-beta1 (Development)

phpMyAdmin 2.6.0-beta1 (Development) 06/24/2004 10:46 PM
Handles the basic adminstration of MySQL over the WWW

phpMyAdmin 2.6.2 (Default branch)

phpMyAdmin 2.6.2 (Default branch) 04/16/2005 07:32 PM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data and administrate one single database and multiple MySQL servers.

phpMyAdmin 2.6.0-alpha is released

phpMyAdmin 2.6.0-alpha is released 04/23/2004 07:13 PM
The phpMyAdmin Project is proud to announce the immediate availability of the first alpha release of phpMyAdmin 2.6.0. Because of significant changes inside the database connection methods and major improvements to the MySQL 4.1 compatibility, the team decided to release this alpha version from phpMyAdmin's current development code. Supporting the new improved MySQL extension of php5 (MySQLi), phpMyAdmin has made a giant step towards the upcoming PHP and MySQL versions. As the new milestone should to be as stable as possible, any feedback about 2.6.0-alpha1 would be appreciated. Please note, that it is not recommended to run this testing release on production environments. (From the announcement text by Alexander Turek).

phpMyAdmin 2.3.3pl1 released

phpMyAdmin 2.3.3pl1 released 12/05/2002 09:38 AM
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the WWW. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields. As a few errors in some language files slipped in version 2.3.3, here is a patched version.

PHP Magazine: Review - Mastering
phpMyAdmin...

PHP Magazine: Review - Mastering
phpMyAdmin... 07/29/2004 08:30 AM
Mastering phpMyAdmin approaches the usage of the popular PHP-based database administration application, phpMyAdmin. It is targeted at "the serious phpMyAdmin user who would like to use this outstanding application to its full power." It is a compliment to the authors of this hugely popular application to say that there is not much for this book to cover, as the interface of phpMyAdmin is famous for its ease of use. Read Mitch Pirtle's review of "Mastering phpMyAdmin for Effective MySQL Management" here - complete with a chapter overview, the style points, and the interesting lowdown.

phpMyAdmin for Effective MySQL
Management

phpMyAdmin for Effective MySQL
Management 12/19/2004 03:24 PM
"As a mission statement, the introduction of a book written for tutorial purposes forms the foundation for judging the success or failure of the subsequent pages. Marc Delisle has written Mastering phpMyAdmin for Effective MySQL Management as a tightly focused tutorial that is as successful at guiding its readers along its stated path as it is at avoiding the common pratfall of straying off target." Story

php codes injection in phpMyAdmin
version 2.5.7.

php codes injection in phpMyAdmin
version 2.5.7. 06/29/2004 02:09 PM
Nasir Simbolon (Jun 28 2004)

PHPClasses.org: Book Review on
phpMyAdmin

PHPClasses.org: Book Review on
phpMyAdmin 05/20/2004 08:41 AM
PHPClasses.org has a new book review posted today covering the Packt book Mastering phpMyAdmin for Effective MySQL Management.
Grok Description matches for Doing More With phpMyAdmin (Part 1)
GrokA matches for Doing More With phpMyAdmin (Part 1)

Mastering phpMyAdmin for Effective MySQL
Management

Mastering phpMyAdmin for Effective MySQL
Management 05/19/2004 07:20 PM
If you have been using or want to use phpMyAdmin and would like to obtain maximum benefit from this Web application, this book will be particularly valuable whether you are developing MySQL database applications in PHP or any other language.

Book Review: Mastering phpMyAdmin for
Effective MySQL Management

Book Review: Mastering phpMyAdmin for
Effective MySQL Management 12/17/2004 06:23 PM
This well-written book by one of the leaders of the phpMyAdmin community covers a lot of ground--and might get you interested in working on the project.

Doing More With phpMyAdmin (Part 1)

The following phrases have been identified by the grok system as matching this entry: import csv to phpmyadmin phpmyadmin-2.6.2-rc1 myisam phpmyadmin creating an identity column phpmyadmin environment how-to "multi user " using "mysql maestro" shared hosting