Today's Best Tech Deals
Picked by PCWorld's Editors
Top Deals On Great Products
Picked by Techconnect's Editors
PhpMyAdmin is the one of the most popular tools for MySQL database administration. A major reason for this is its portability--phpMyAdmin runs in a Web browser, so you can access it from almost any computer. The program is also robust; phpMyAdmin has enough functionality that you can probably create and run a Web site without knowing any SQL. Being free and open-source never hurt anybody, either. For these reasons, most hosting sites include phpMyAdmin in their control panel as the default MySQL administration tool.
Installation of phpMyAdmin on a server is simple, assuming you already have PHP and MySQL running. Full instructions can be found in the official wiki, but the process is little more than extracting files and running a setup script. phpMyAdmin has visual interfaces for most MySQL tasks, including creating, browsing, and editing tables. There's a relation view for linking tables using foreign key relationships (make sure you're using the InnoDB storage engine-MyISAM doesn't support foreign keys). phpMyAdmin will also execute custom SQL queries, so it's just as powerful as the standard command line utility. In fact, phpMyAdmin does more. Besides the convenience of a more interactive, visual interface, phpMyAdmin has some nice extras, such as importing and exporting Excel, OpenDocument, and XML files, and a tool that generates a PDF image of your database schema.
Unlike many standalone MySQL admin tools, phpMyAdmin does not have syntax coloring or code completion. But while you might think that running in a browser would make phpMyAdmin slower, the pages are light enough that you won't notice lag between page loads. For me, phpMyAdmin was zippy in both Firefox and IE. So unless you're an expert developer who relies on writing complex SQL queries, phpMyAdmin is an ideal tool.
Samsung promo codes for September 2019
$350 off Samsung Galaxy S10 or S10+ or S10e - Samsung promotions
$10 off | 16 HP Coupon Codes and Sales | PCWorld
Take $10 off on $50 accessories order with HP coupon code
Newegg promo codes for September 2019
50% off Newegg's refurbished outlet
AT&T Wireless promo codes for September 2019
$300 reward card with the new iPhone 11 Pro Max - AT&T offer
Shop with a Verizon promo codes for September 2019
Switch to Verizon and get $250 rebate with Verizon promotions
15% off | 10 OnePlus Promo Codes and Sales | PCWorld
Get 15% off on OnePlus 7 Pro Premium Bundle