Mysql workbench ��� ��������� ������ mac os

MySQL Workbench: Administration

MySQL Workbench integrates database administration tools into a simple to use graphical user interface. The visual console enables DBAs to easily perform operations such as configuring servers, administering users, export and import, and viewing logs.

Backup & Recovery

Audit

Server Configuration

Start/Stop Server

Export/Import

Backup/Recovery

Easily create and manage online MySQL backups using the Workbench GUI for MySQL Enterprise Backup. Simple to setup, run, schedule, and view backups while in progress, this tool helps to quickly put proper backups in place. When its time to restore, the GUIs assesses the history — what, when, and where — and steps a DBAs through the recovery process.

Auditing

Easily enable MySQL Enterprise Audit and see who did what, when, where and how. Using built in filters and text search, DBAs can easily find suspect activity in your audit trails. MySQL Workbench provides a powerful grid view and enables DBAs to quickly page through data and sort across nine attributes such as user, ip, activity type, date and time.

User Administration

Administering users, granting privileges and viewing privilege information has never been easier. Using MySQL Workbench DBAs can visually add users, assign passwords and setup user profiles. Assigning and revoking global and database privileges is as easy as adding and removing privilege items from an available list.

Server Configuration

MySQL Workbench allows DBAs to easily view and edit general and advanced parameters to quickly fine tune MySQL servers.

Server Connections

Improve server management with a comprehensive view of all server connections and visual tree based navigation provides detailed information about server and status variables, including number of threads, bytes sent and received by clients, buffer allocations size, and more.

NEW! SSL Certificate Wizard

The SSL Certificate Wizard helps create proper SSL certificates for both MySQL clients and MySQL servers. Connections in MySQL Workbench are updated with the certificates by the wizard.

Server Logs

View all the MySQL log files including error logs, binary logs, and InnoDB logs from a single, centralized administration environment to diagnose server problems quicker and track database changes.

Export/Import

MySQL Workbench includes visual tools for mysqldump. Easily export/import data by selecting the database schemas and/or tables from the Object Browser. Advanced configurations are available for concurrency controls, backup type, and output formatting.

NEW! Table Data Import/Export Wizard for JSON and CSV

The Table Data Import/Export Wizard supports import and export of JSON and CSV files allowing for easy interoperability with MySQL tables. The new Table Data Import/Export Wizard also provides flexible configuration options including separators, column selection, encoding selection, and more.

Service Control

Start and stop MySQL servers and view corresponding log messages.

System Status

Get an immediate view into the basic health indicators and counters within a MySQL environment. Easily see key values such as available features, primary server directories, replication state, and security settings for authentication and ssl. Simple reports and graphs enable DBAs to easily track memory usage, connections, hit rates, and more.

Источник

MySQL Workbench
Download Now »

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.

MySQL Workbench Home

Visual Database Design

SQL Editor

Performance Dashboard

Design

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
Learn More »

Develop

MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric. The Object Browser provides instant access to database schema and objects.
Learn more »

Administer

MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health.
Learn more »

Visual Performance Dashboard

MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. DBAs can quickly view key performance indicators using the Performance Dashboard. Performance Reports provide easy identification and access to IO hotspots, high cost SQL statements, and more. Plus, with 1 click, developers can see where to optimize their query with the improved and easy to use Visual Explain Plan.
Learn More »

Database Migration

MySQL Workbench now provides a complete, easy to use solution for migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL. Developers and DBAs can quickly and easily convert existing applications to run on MySQL both on Windows and other platforms. Migration also supports migrating from earlier versions of MySQL to the latest releases.
Learn more »

Источник

MySQL Workbench Features

MySQL Workbench is offered in the following Editions:

• MySQL Workbench Community Edition — Open Source (GPL License)
• MySQL Workbench Standard Edition — Commercial
• MySQL Workbench Enterprise Edition — Commercial

MySQL Workbench Community	MySQL Workbench SE	MySQL Workbench EE
Download »	Download »	Download »
Visual SQL Development
SQL Editor	Write, run and debug SQL statements	√	√	√
SQL Code Completion	Context-sensitive list of SQL keywords and objects, for more efficient coding	√	√	√
SQL Code Formatter	Automatically formats SQL code to make code more readable	√	√	√
SQL Syntax Highlighting	Color syntax highlighting	√	√	√
SQL Code Generation	One-Click SQL code generation	√	√	√
SQL Snippets	Reuse your favorite SQL snippets	√	√	√
SQL History	Running history of all executed SQL	√	√	√
Visual Database Administration
Server Stop/Start	Stop/Start servers locally and remotely	√	√	√
Server Status & Health	View key server diagnostic information (Status, CPU, Memory, Hit rate, Network Traffic)	√	√	√
Server Logs	View and parse slow and error logs (if table based)	√	√	√
Server Configuration	View and edit MySQL Server settings	√	√	√
Replication Configuration	View and edit MySQL Replication settings	√	√	√
Performance Tuning
Performance Dashboard	Single location to quickly view key performance indicators	√	√	√
Top Performance Reports	Over 20 reports on hot spots, IO, SQL, and more	√	√	√
Query Results View	View key query performance metrics, stats, and timing	√	√	√
Visual Explain	Visually analyze query execution plans	√	√	√
User and Session Management
Application Roles	Convenient grouping of privileges for users	√	√	√
User Management	View, edit, create, delete and clone MySQL users and privileges	√	√	√
Session Management	View status of connections and kill	√	√	√
Connection Management
Connection Wizard	Configure connections to MySQL Servers	√	√	√
Multiple Connections	Define multiple, simultaneous connections to different servers	√	√	√
SSH-Tunneling	Configure SSH connections to local and remote servers	√	√	√
Object Management
Schema Inspector	Detailed views on meta-data for all schema objects with access to maintenance operations	√	√	√
Object Browser	Easily navigate, explore, and perform actions on database objects (tables, views, triggers, etc.)	√	√	√
Object Editor	Easily edit, create or delete database objects (tables, views, triggers, etc.)	√	√	√
Data Management
Import/Export	Import and export mysqldump files	√	√	√
Export Result Sets	Export result sets as CSV, XML, HTML	√	√	√
Visual Data Editor	View and edit result sets in grid	√	√	√
Multi-Pane Result Sets	View multiple result sets in the same visual data window	√	√	√
Vertical query results mode	Formats Query results in columnar versus traditional row format	√	√	√
Quick Find	Quickly locate hard to find rows or cells	√	√	√
Table Data Search	Pattern matching search for data search across all tables and schemas	√	√	√
Large Result Set Limits	Limit number of rows returned for large result sets	√	√	√
Visual Data Modeling
ER Diagramming	Complete entity-relationship diagramming	√	√	√
Choice of Diagramming Notation	Choose from popular modeling notations	√	√	√
Auto Layout	Automatically arrange large models	√	√	√
Model Tables, Indexes, Views	Manage all MySQL data-related objects	√	√	√
Model Stored Procedures, Triggers, Functions	Manage all MySQL code-related objects	√	√	√
Model User Security	Manage MySQL security privileges in model	√	√	√
Reverse Enginnering
Reverse Engineer from SQL Script	Create models from SQL text scripts	√	√	√
Reverse Engineer from Live Database	Create models from live databases	√	√	√
Forward Enginnering
Forward Engineer to SQL Script	Generate DDL that runs right the first time to a SQL script	√	√	√
Forward Engineer to Live Database	Generate a complete physical database from a model	√	√	√
Schema Synchronization
Schema Diff	Understand the differences between a model and a live database or SQL script	√	√	√
Schema Synch to SQL Script	Automatically update a model or SQL script in either direction	√	√	√
Schema Synch to Live Database	Automatically update a model or live database in either direction	√	√	√
Schema & Model Validation 1
General Schema Validation	Enforces data modeling best practice standards and eliminates common modeling errors	√	√
MySQL-specific Schema Validation	Enforces MySQL-specific design standards and ensures physical schemas are built correctly the first time	√	√
Model Validation	Ensure model is free from errors	√	√
DBDoc 1
Document database schemata	Automate documentation of databases	√	√
Document all SQL object types	Include information about all aspects of a database or model	√	√
Document output in multiple formats	Publish in HMTL or text	√	√
GUI for MySQL Enterprise Backup 1
Automate Backups	Easily create, configure, run and schedule MySQL Enterprise Backup full and incremental backups	√
Track and manage	Track status on previous backups, view progress on running backups, and review job schedules	√
Recover Quickly	Easily restore by selecting from the most recent backup or use history to recover an older version	√
GUI for MySQL Enterprise Audit 1
Audit sensitive data	Easily enable MySQL Enterprise Audit and see who did what, when, where and how	√
Investigate suspicious activity	Easily find suspect activity in your audit trails using built in filters and text search	√
Sortable Grid View	Powerful grid view, quickly page through data and sort across nine attributes such as user, ip, activity type, date and time	√
GUI for MySQL Enterprise Firewall 1
Protect from SQL injection Attacks	Easily enable MySQL Enterprise Firewall and Learn or Create Firewall Rules	√
Learn, Block, or Alert	Simple to set Firewall Modes within Workbench	√
View, Export, Import Rules	Review rules per user, simply export and import rules for simple cross user or server sharing	√
Scripting & Plugins
Python Plugins	Customize with Python plugins	√	√	√
Import from DBDesigner	Easily import models from DBDesigner	√	√	√
Export Model Diagrams	Easily export as PNG, SVG, PDF, Postscript	√	√	√
Database Migration
Database Migration Wizard	Migration from Microsoft SQL Server, Sybase ASE, Sybase SQL Anywhere, PostgreSQL, and SQLite	√	√	√

1 Features only available with specified MySQL Commercial Editions (SE or EE or CGE)

Источник