Mysql SQLyog using the detailed

How to create a database

The first step is to create the database by right-click root node.

The second step, fill in the database name, select the default character set and so on after the point OK.

How to back up and restore a database

Steps to back up a database

First step: Back up the database, backup/export, right-click the database you want to back up.

The second step is to set the SQL dump interface to suit your needs.

1: data, structure, or both can be backed up as needed.

2: Select the location where the backup file is stored.

3: Tick the content you want to back up.

4: Select the content to write to the file according to your own needs, such as create Database,use Database and other statements.

Third step, click Export.

Steps to restore a database

The first step, right-click the database you want to restore to, import-Execute SQL script.

The second step is to select the previously backed up files in the Restore Database interface.

Third step, click ' Execute '.

Some operations on database tables

3.1 Backing up table data

Right-select the table-by-backup table under a database as a SQL dump.

The following steps can refer to the method of backing up the database.

3.2 Restoring table Data

Same as the steps to restore a database.

3.3 How to view and modify table structures and indexes

The first step, right-click Table, change the table to open more information about the table.

The second step is to modify the table structure and index information in the Open interface. For example, the diagram that modifies the Index property to Fulltext is as follows.

How to create users and authorized users for database operations

The first method: Add users and authorize them in SQLyog.

The first step is to create a new connection as the root account.

The second step, select Tools-User management.

The second step, fill in the user name, select host localhost or%, enter the password, save the changes can create the user.

The third step, in the second step after saving changes in the upper right corner of the user is corresponding to [email protected]% or [email protected] (Figure 1), and then select the database to be authorized, such as EXJC6 (Figure 2) Next, the right to grant the operation is exjc6 by ticking to the selected database prior to the specific operation.

The second method: Create users and authorizations in the command window.

The steps for database authorization using commands are as follows:

@>mysql –u root –pmysql>grant all privileges on exjc6.* to [email protected]’%’ (identified by PASSWORD(‘123’));mysql>flush privileges;

Description

All means all rights (including add, delete, change, check and other rights);

Exjc6. indicates that there are all operations permissions on the EXJC6 database, . * Indicates that all operations permissions are available for all databases;

IYou for the added user name;

123 for the password;

% to match all hosts, that is, all hosts can access the EXJC6 database, localhost means matching the local machine;

After execution, a record is inserted in the Mysql.user table and a user named IYou is added;

The above information can be specified such as: Grant Select,update on exjc6.* to [email protected] identified by ' 123 ".

How to compare and synchronize the differences between two databases

The first step is to select the Advanced tool, the Schema Sync tool.

Second, select the two databases you want to compare, and the database you want to modify is placed in the target source on the right.

In the third step, you can choose to compare tables or compare all objects (tables, functions, triggers, stored procedures, and so on) as needed, and then click Compare to show the results of the comparison. The result is marked with the specific color of the object created or modified, and in the lower left corner to show the specific content.

Fourth step, click Execute all, you can synchronize the right database into the database with the same structure on the left. It is necessary to note that this synchronization contains only the table structure and does not contain table data.

SQLyog expired, how to crack

I use SQLyog 9.63, only one months of probation, how to exceed the trial period, how to do?

At this point I can tell you a solution, which is to get a one-month trial period by deleting the registry key. Here's how it works:

The first step, enter regedit in the Run window, enter the Registry Editor.

In the second step, the {8e919370-*} items of the red callout are found by path Hkey_current_user->software.

The third step, right click on the item, select Delete, then click Yes.

Mysql SQLyog using the detailed