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@% |