支持Windows和Linux的免费 MySQL GUI 管理工具集合

jopen 10年前

下面是一些非常好的Mysql免费图形用户界面管理工具列表,包括Windows和Linux:

 

支持Windows和Linux的免费 MySQL GUI 管理工具

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
  • 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

Download Link:   http://www.phpmyadmin.net/

 

支持Windows和Linux的免费 MySQL GUI 管理工具

2)     Heidisql: [Freeware]

A cool mysql client application, can be install on desktop easy and very handy to use.

Major features are:

  • 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

Download link: http://www.heidisql.com/

 

支持Windows和Linux的免费 MySQL GUI 管理工具

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

 

支持Windows和Linux的免费 MySQL GUI 管理工具

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

 

支持Windows和Linux的免费 MySQL GUI 管理工具

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.

  • 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.

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

支持Windows和Linux的免费 MySQL GUI 管理工具

Features:

Supports all versions of MySQL database server (3.23,4.0,5.0,5.1,5.4)
  • Tables
  • Views
  • UDFs
  • Stored procedures
  • Triggers
  • Events
  • InnoDB tables
  • Foreign Keys
  • UTF-8 Data

Types of connection to the database

  • SSH Tunnel Support
  • SSL Support
  • Standard Connection to MySQL database API
  • Direct connection to the database via TCP-IP

Comprehensive object management

  • Create and delete databases/li>
  • Manage tables, fields, indexes, foreign keys
  • Manage views, stored procedures, triggers, UDF and scheduled events
  • Duplicate database objects

Data Handling

  • 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

Advanced visual SQL query builder and text

  • 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>

Options for exporting and importing data

  • 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

Options for monitoring the database

  • Monitor sessions
  • Graphical utility for database status
  • Graphical utility for tables status

Advanced options for synchronizing the database

  • Utility to synchronize schemas of two databases
  • Utility to synchronize data of two databases

Reports module

  • Multiple database reports

Options for customizing the IDE

  • 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

Website : http://www.sqldeveloper.net/database-tools/mysql/overview.html