I have a MySQL database which has a few stored procedures, functions, and tables.
The problem I face is when I try to load the MySQL Database in MySQL WorkBench 6.3, it shows only Tables. Views, Stored Procedures, Triggers, and functions are not visible.
When I searched online for this, a few people suggested changing the value of lower_case_table_names to 1. I did that too, but still, it doesn't load any stored procedures or functions.
One more thing: I tried to connect to the same MySQL database using SQLYog. There it shows all the stored procedures and functions. Can anyone tell me the reason for this cause and a possible fix?
Here are the screenshots of MySQL Workbench and SQL Yog respectively.