10 MySQL tools that can simplify the PHP development process_PHP Tutorial

MySQL Workbench

MySQL Workbench是一个由MySQL开发的跨平台、可视化数据库工具。它作为DBDesigner4工程的替代应用程序而备受瞩目。MySQL Workbench可以作为windows、linux和OS X系统上的原始GUI工具，它有各种不同的版本，你可以查看下面的链接以获得它的版本信息。

MySQL Workbench版本信息

点此下载

phpMyAdmin

phpMyAdmin是一款免费的、用PHP编写的工具，用于在万维网上管理MySQL，它支持MySQL的大部分功能。这款含有用户界面的软件能够支持一些最常用的操作（比如管理数据库、表格、字段、联系、索引、用户、许可，等等），同时你还可以直接执行任何SQL语句。

它所具备的特性：

>直观的Web界面

>支持大多数MySQL功能：

     > 浏览和丢弃数据库、表格、视图、字段和索引

      >创建、复制、删除、重命名以及更改数据库、表格、字段和索引

      >维护服务器、数据库以及表格，能对服务器的配置提出建议

      >执行、编辑和标注任何SQL语句，甚至批量查询

       >管理MySQL用户以及用户权限

>管理存储的过程（stored procedures）和触发器（triggers）

>从CSV 和 SQL文件格式中导入数据

>能够以多种格式导出数据：CSV、SQL、XML、PDF、ISO/IEC 26300等

>管理多台服务器

>为数据库布局创建PDF图表

>使用Query-by-example (QBE)创建复杂的查询

>在数据库中进行全局搜索，或者在数据库的子集中进行搜索

>用预定义的函数把存储的数据转化成任何格式

>还具有其他更多特性...

点此下载

Aqua Data Studio

对于数据库管理人员、软件开发人员以及业务分析师来说，Aqua Data Studio是一个完整的集成开发环境（IDE）。它主要具备了四个方面的功能：1）数据库查询和管理工具；2）一套数据库、源代码管理以及文件系统的比较工具；3）为Subversion（SVN）和CVS而设计了一个完整的集成源代码管理客户端；4）提供了一个的数据库建模工具（modeler），它和最好的独立数据库图表工具一样强大。

点此下载

SQLyog

SQLyog是一个全面的MySQL数据库管理工具（/'GUI'/'Frontend'）。 它的社区版（Community Edition）是具有GPL许可的免费开源软件。这款工具包含了开发人员在使用MySQL时所需的绝大部分功能：查询结果集合、查询分析器、服务器消息、表格数据、表格信息，以及查询历史，它们都以标签的形式显示在界面上，开发人员只要点击鼠标即可。此外，它还可以方便地创建视图和存储过程，最近几周笔者一直在反复使用这个功能。

点此下载

MYSQL Front

这个MySQL数据库的图形GUI是一个“真正的”应用程序，它提供的用户界面比用PHP和HTML建立起来的系统更加精确。因为不会因为重载HTML网页而导致延时，所以它的响应是即时的。如果供应商允许的话，你可以让MySQL-Front直接与数据库进行工作。如果不行，你也只需要在发布网站上安装一个小的脚本即可。登录信息会存储在你的硬盘上，因此你不必再登录到不同的网络界面上了。

点此下载 

mytop

mytop是一款基于控制台的工具（不是GUI），用于监视线程以及MySQL 3.22.x、3.23.x和4.x服务器的整体性能。它可以在大多数安装了Perl、DBI以及 Term::ReadKey的Unix系统上（包括Mac系统OS X）运行。如果你安装了Term::ANSIColor，你能得到彩色的视图。如果你安装了Time::HiRes，你还可以得到一个不错的 “每秒查询数” 实时统计。mytop0.7版甚至还能在windows上运行。

mytop is inspired by the system monitoring tool "top". I frequently use top on Linux, FreeBSD, and Solaris, and you will most likely notice certain features from these operating systems in mytop. After mytop is connected to a MySQL server, it can periodically run the SHOW PROCESSLIST and SHOW STATUS commands and summarize the information obtained from these commands in a useful format.

Click here to download

Sequel Pro

Sequel Pro is an application for managing MAC OSX databases. It allows you to directly access MySQL databases on local and remote servers, and supports importing and exporting data from popular file formats, including SQL, CSV and XML and other files. Initially, Sequel Pro was just a fork of the open source CocoaMySQL project. Some features are as follows:

> You can easily establish a connection to the local MySQL server on your Mac

>It has all table management functions, including indexes.

>Support MySQL view

> It uses multi-window functionality to support multiple databases or tables instantly

Click here to download

SQL Buddy

SQL Buddy is a powerful lightweight Ajax database management tool. It's very easy to install, you just need to unzip the folder into the server, it couldn't be easier! You can also perform most common operations. This tool also has many useful shortcuts, which you can check out here: SQL Buddy Keyboard Shortcuts.

Click here to download

MySQL Sidu

MySQL Sidu is a free MySQL client that runs through a web browser and is very easy to use! The letters Sidu stand for Select, Insert, Delete and Update. Sidu actually has more functions. It looks more like the GUI of MySQL front-end software than a web page.

>SIDU supports SQL selection, insertion, deletion, and update functions.

>SIDU supports working on browsers such as Firefox, IE, Opera, Safari, Chrome, etc.

>SIDU looks like a GUI for MySQL front-end software rather than a web page.

>SIDU can work with MySQL, Postgres and SQLite DBs.

Click here to download

Navicat Lite MySQL Admin Tool

Navicat is a fast and reliable database management tool that is very popular with everyone. Navicat is specially designed to simplify database management and reduce management costs. It is designed to meet the needs of database managers, database developers and the majority of small and medium-sized enterprises. It has a very intuitive GUI that allows you to create, organize, access and Share information.

For MySQL, Navicat tool is a powerful database management and development tool. It can work with any version of the MySQL database server (version 3.21 or above) and supports most of the latest MySQL functions, including Trigger, Stored Procedure, Function, Event, View and Manage User, etc. Navicat Lite is free to download, but is intended for non-commercial use only.

Click here to download