支持Windows和Linux的免費 MySQL GUI 管理工具集合
下面是一些非常好的Mysql免費圖形用戶界面管理工具列表，包括Windows和Linux：
1) phpMyAdmin: [Freeware]
一個非常強大和流行的，基于Web的 MySql GUI，支持所有MySQL提供的所有功能。非常易于配置和安裝，支持多平臺。
very useful when SSH-tunnel is not available.
Major Features are:
- Intuitive web interface
- Support for most MySQL features:
- Import data from CSV and SQL
- Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, LATEX and others
- Administering multiple servers
- Creating PDF graphics of your database layout
- Creating complex queries using Query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link </ul>
- browse 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
- manage MySQL users and privileges
- manage stored procedures and triggers </ul>
- Free for everyone, OpenSource.
- Connect to multiple servers in one window
- Connect to servers via commandline
- Connect via SSH tunnel, or pass SSL settings
- Create and edit tables, views, stored routines, triggers and scheduled events.
- Generate nice SQL-exports
- Export from one server/database directly to another server/database
- Manage user-privileges
- Import text-files
- Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
- Browse and edit table-data using a comfortable grid
- Bulk edit tables (move to db, change engine, collation etc.)
- Batch-insert ascii or binary files into tables
- Write queries with customizable syntax-highlighting and code-completion
- Pretty reformat disordered SQL
- Monitor and kill client-processes
- Find specific text in all tables of all databases of one server
- Optimize and repair tables in a batch manner
- Launch a parallel mysql.exe command line window using your current connection settings </ul>
- Rich context menus etc. for performing common tasks without writing SQL.
- Visual Schema Designer.
- Visual Query Builder.
- Query Formatter.
- Connectivity options: Direct client/server using MySQL API (SSL supported), HTTP/HTTPs Tunneling, SSH Tunneling. </ul>
- Tables
- Views
- UDFs
- Stored procedures
- Triggers
- Events
- InnoDB tables
- Foreign Keys
- UTF-8 Data
- SSH Tunnel Support
- SSL Support
- Standard Connection to MySQL database API
- Direct connection to the database via TCP-IP
- Create and delete databases/li>
- Manage tables, fields, indexes, foreign keys
- Manage views, stored procedures, triggers, UDF and scheduled events
- Duplicate database objects
- Add, view, edit, search, group, sort and filter data
- Ability to copy and paste data directly from Excel
- Ability to delete selected records
- Able to export data into SQL inserts
- Able to create master detail relationships between unlimited number of tables
- Utility to handle LOV
- Advanced filter data builder
- SQL Editor with autocomplete, syntax highlighting, code folding, description of objects, code proposal and parameters manager/li>
- Query builder to build SQL’s without previous knowledge required
- SQL Code Formatter
- Running scripts
- Parameters auto-replace/li>
- Utility to export data and structure from database like MySQL dump
- Utility to transfer data from the database
- Utility to export in multiple formats (MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF)
- Utility to import in multiple formats (MS Excel, MS Access, DBF, XML, ODF, TXT and CSV)
- Advanced options for export and import at the level of the data grid
- Utility to import data directly from Excel
- Simple export of data into a table
- Monitor sessions
- Graphical utility for database status
- Graphical utility for tables status
- Utility to synchronize schemas of two databases
- Utility to synchronize data of two databases
- Multiple database reports
- Options to modify the behavior of the IDE
- Options to modify the behavior of the SQL editor
- Options to change the behavior of the data grid
Download Link: http://www.phpmyadmin.net/
2) Heidisql: [Freeware]
A cool mysql client application, can be install on desktop easy and very handy to use.
Major features are:
Download link: http://www.heidisql.com/
3) Msql Workbench: [Freeware]
Very powerful standalone mysql client for mysql development, administration, data export, migration, optimization. Available for windows and Linux
Major Features supported are:
SQL Development, Database Administration, Server Status & Health, Server Configuration, Replication Configuration, User and Session Management, Application Roles, Session Management, Multiple Connections, SSH-Tunneling, Data Management, Table Data Search, Visual Data Modeling, ER Diagramming, Model Stored Procedures, Triggers, Functions, Schema Synchronization, Backups, Database Migration
Download Link: MySql Workbench
4) Toad for MySQL: [Freeware]
Great tool for mysql development and administration, provides various features as well as different ways connection including database on aws.
Download Link: http://www.quest.com
5) SqlYog Community Edition: [Freeware]
one of the popular client for mysql, very powerful available for windows, Linux .
Features: ? Data manipulations (INSERT, UPDATE, DELETE) may be done from a spreadsheet-like interface. Both raw table data and a result set from a query can be manipulated.
Backup Tool for performing unattended backups. Backups may be compressed and optionally stored as a file-per-table as well as identified with a timestamp.
Downlod Link: SqlYog
Official website: https://www.webyog.com/
6) DreamCoder for MySQL
A great tool for managing database as well as scripting like PHP, Java, HTML etc
Features:
Types of connection to the database
Comprehensive object management
Data Handling
Advanced visual SQL query builder and text
Options for exporting and importing data
Options for monitoring the database
Advanced options for synchronizing the database
Reports module
Options for customizing the IDE
Website : http://www.sqldeveloper.net/database-tools/mysql/overview.html