mysql 'root'@'localhost'&‘root’@‘%’区别

时间：2014-11-06 22:07:25 收藏：0 阅读：2478

1.%允许来自任何ip的连接
   localhost允许本机的连接

2. dbfor studio mysql 6.2.280

  %的情况，使用backup databases,倒出来的SQL文件，在另外一个数据库中导入（restore database）不进去

  localhost的情况，使用backup databases,倒出来的SQL文件，在另外一个数据库中可以正常导入
3.  select * from mysql.proc可以看到他们的区别(procedure和function一样)
db                name          type         specific_name lanage  sql_data_access                                                                                 definer 
work inventory_held_by_customer FUNCTION inventory_held_by_customer SQL READS_SQL_DATA NO DEFINER       root@localhost
work inventory_in_stock FUNCTION inventory_in_stock SQL READS_SQL_DATA NO DEFINER       root@localhost
game F_Dep_GetChildList FUNCTION F_Dep_GetChildList SQL CONTAINS_SQL NO DEFINER       user01@%
game F_Get_TaskDeviationEstimate FUNCTION F_Get_TaskDeviationEstimate SQL CONTAINS_SQL NO DEFINER       user01@%

原文：http://blog.csdn.net/lzq123_1/article/details/40863971

work	inventory_held_by_customer	FUNCTION	inventory_held_by_customer	SQL	READS_SQL_DATA	NO	DEFINER	root@localhost
work	inventory_in_stock	FUNCTION	inventory_in_stock	SQL	READS_SQL_DATA	NO	DEFINER	root@localhost
game	F_Dep_GetChildList	FUNCTION	F_Dep_GetChildList	SQL	CONTAINS_SQL	NO	DEFINER	user01@%
game	F_Get_TaskDeviationEstimate	FUNCTION	F_Get_TaskDeviationEstimate	SQL	CONTAINS_SQL	NO	DEFINER	user01@%

mysql &#39;root&#39;@&#39;localhost&#39;&amp;‘root’@‘%’区别

mysql 'root'@'localhost'&‘root’@‘%’区别