1

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.

mysql workbench

sql yog

7
  • 1
    It sounds like the account needs to be Granted SHOW VIEW on the applicable schemas. Give that a simple try, grant the account SHOW VIEW and this can be done via MySQL Workbench too; Object Rights | select SHOW VIEW. – IT Thug Ninja Mar 28 '18 at 5:38
  • Hi @PimpJuiceIT, Thanks for replying. I have tried what you suggested, looks like the Show View in Object Rights is already selected. Any other solution? – Pankaj Rathi Mar 28 '18 at 9:53
  • Perhaps one of these answers will help you.... dba.stackexchange.com/questions/95529/… – IT Thug Ninja Mar 28 '18 at 11:55
  • I have already tried with those solutions. None of them work for me. Actually, I'm using SSMA (SQL Server Migration Assistant) to migrate from MySQL to MS SQL and even in the tool (SSMA) it doesn't show stored procedures, functions, etc. So I thought might be if we fix it on the MySQL workbench that will help the tool too. As the tool (SSMA) and the MySQL workbench are behaving in the same manner. – Pankaj Rathi Mar 29 '18 at 3:24
  • That's interesting I've never migrated from MySQL to MS SQL but I know both technologies for sure. It'd be interesting hear about success with stored procedure logic such as TOP # vs LIMIT # and those type differences in the SQL logic MySQL uses and T-SQL, functions, etc. I know with MS SQL SSMS you can GRANT VIEW DEFINITION to be able to see SPs populate in the explorer pane or whatever. – IT Thug Ninja Mar 29 '18 at 3:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.