MySQL ' root ' @ ' localhost ' & ' root ' @ '% ' difference

1.% allow connections from any IP   localhost to allow native connections

2. dbfor Studio MySQL 6.2.280

  % of cases, use Backup databases, pour out the SQL file, import in another database (RESTORE database) does not go in

  localhost, using Backup databases, pour out the SQL file, in another database can be imported normally
3. Select * from Mysql.proc can see their differences (Procedure and function)
DB                name          type         specific_name lanage  sql_data_access                                                                                 
   
   TD width= "style=" width:54pt ">inventory_held_by_customer 
      TD width= "style=" width:54pt ">inventory_held_by_customer 
     

    
    
     
   
    
   
 
    
 
     
work 
function 
sql 
 
     
reads_sql_data 
 
     
no 
 
     
definer 
 
     
  
 
     
  
 
     
  
 
     
 [email protected]  
 
    
 
    
 
     
Work
 
     
Inventory_in_stock
 
     
FUNCTION
 
     
Inventory_in_stock
 
     
Sql
 
     
Reads_sql_data
 
     
NO
 
     
Definer
 
     
 
     
 
     
 
     
[Email protected]
 
    
 
    
 
     
Game
 
     
F_dep_getchildlist
 
     
FUNCTION
 
     
F_dep_getchildlist
 
     
Sql
 
     
Contains_sql
 
     
NO
 
     
Definer
 
     
 
     
 
     
 
     
[Email protected]%
 
    
 
    
 
     
Game
 
     
F_get_taskdeviationestimate
 
     
FUNCTION
 
     
F_get_taskdeviationestimate
 
     
Sql
 
     
Contains_sql
 
     
NO
 
     
Definer
 
     
 
     
 
     
 
     
[Email protected]%
 
    
 
   
   
  

MySQL ' root ' @ ' localhost ' & ' root ' @ '% ' difference