"MySQL novice user's Manual"

Create database 1, directly on the shortcut key Ctrl+d, the following dialog box appears, select "Create" as needed, OK to add the user and add users to the added user authorization ①sqlyog and authorize the added user. 1. Create the connection as a "root" user and log in successfully. 2, select "Tools" → "User management" (or directly on the shortcut key "Ctrl+u")
Complete the filling according to your own situation. After the save is complete, the new user will appear in the left and right place. And then select it. The following window will appear.
Then save as you choose. @ is created with a command window.

 
   
  
 
    
   
< Span class= "pun" >@> mysql  –  u root  –  p   
 
    
   
 mysql  >  grant all privileges on database  .*   to User name @      ( identified  by   PASSWORD   ('  123    
 
    
   
mysql  >  flush privileges    
 
   
  

Description: All: Indicates that all permissions have been assigned to and from the search and change. Database name. *: Indicates that there are all operations permissions on the corresponding database. User name: For the above example, the user name that you just added. %: Indicates that all hosts are matched. Database backup and restore steps for backing up the database: "Select database to back up" → "Backup/export" → "Back Up database dump to SQL" to the following interface
"Then set it according to your needs."
Steps to restore a database: Select database to restore right-click → import → Execute SQL scriptto the following interface
"Select a previously backed up file to start the restore, click" OK "

How to compare the differences between two databases and synchronize them "first step, select Advanced ToolsThe schema Synchronization tool."
Second, select the two databases you want to compare, and the database you want to modify is in the target source on the right.

The third step, according to the needs can choose Compare tables only or Compare all Objects (tables, functions, triggers, stored procedures, and so on), 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.

How to use the trial version indefinitely

" first step, enter regedit in the Run window , enter the Registry Editor "

" The second step, by Path Hkey_current_user->software find the {8e919370-*} item in the red Callout

"The third step, delete can"

From for notes (Wiz)

"MySQL novice user's Manual"