MySQL Study--mysql management tool SQLyog

MySQL Study--mysql management tool SQLyog

SQLyog is an easy-to-use, fast and concise tool for graphically managing MySQL databases, and it is able to manage your database efficiently from any location!

The SQLyog Database Synchronization Wizard will guide you through the data synchronization steps between the two databases and will also help you schedule the database synchronization process. The work file stores the configuration for this task. You can use a working file to run this task in the future. The Schedule Backup Wizard guides you through the steps to schedule the export of SQL data, which you can use to generate an SQL file or multiple files from the exported data.

First, the installation of SQLyog

You can download the cracked version from the internet to use 650) this.width=650; "style=" Border-bottom:medium none;border-left:medium none;border-top:medium None;border-right:medium none; "alt=" Smile "src=" Http://static.blog.csdn.net/xheditor/xheditor_emot/default/smile.gif "/>

1. Installation

2. Connect to the database

Authorization on the database side:

[[email protected] ~]# mysql-u root-p
Enter password: 
Welcome to the MySQL monitor.  commands end with; or \g.
Your MySQL Connect Ion ID is 3

mysql> Select version ();
+-------------+
| version ()   |
+-------------+
|   5.6.25-73.1   |
+-------------+
1 row in Set (0.00 sec)
mysql> Grant all on * * to ' root ' @ ' 192.168.8.254 ' identified By ' Oracle ';
Query OK, 0 rows affected (0.01 sec)

Second, the use of SQLyog

650) this.width=650; "Style=" Border-bottom: Medium None;border-left:medium None;border-top:medium none;border-right:medium none; "Src=" http://img.blog.csdn.net /20150814173209616?watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center "/>

database management

650) this.width=650; "Style=" Border-bottom: Medium None;border-left:medium None;border-top:medium none;border-right:medium none; "Src=" http://img.blog.csdn.net /20150814173247815?watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center "/>

Stored procedure management

650) this.width=650; "Style=" Border-bottom: Medium None;border-left:medium None;border-top:medium none;border-right:medium none; "Src=" http://img.blog.csdn.net /20150814173318578?watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center "/>

table Management

SQLyog also has more features, such as backup and so on, you can install the use, more digging and play its powerful features! 650) this.width=650; "style=" Border-bottom:medium none;border-left:medium none;border-top:medium none;border-right: Medium none; "alt=" Smile "src=" Http://static.blog.csdn.net/xheditor/xheditor_emot/default/smile.gif "/>

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1684744

MySQL Study--mysql management tool SQLyog