Menu
How can I view the list of user defined functions in mysql database using phpmyadmin.
Mysql database has been migrated from one server to another server and user defined custom functions are not working. I need to view the list of user defined function to check whether they exist in database or not.
Fatal error: db::execute() Could not execute: FUNCTION database.xxx does not exist (SQL: SELECT Function(field) FROM users in file.php on line xx
396
Listing all functions in a MySQL database can be done using SHOW FUNCTION STATUS WHERE db = 'your_database_name'; command.
By enabling $cfg['Servers'][$i]['users'] and $cfg['Servers'][$i]['usergroups'] you can customize what users will see in the phpMyAdmin navigation. This feature only limits what a user sees, they are still able to use all the functions.
When you open the phpMyAdmin home page, click on Databases and then select a database to manage by clicking its name. In the page that opens you will see a list with the database tables, the allowed actions with them, the number of the records, the storage engine, the collation, the tables' sizes, and the overhead.
The following MySQL query will list the user-defined routines.
select * from information_schema.routines;
That will give you all the information about your custom functions/procedures:
select specific_name, definer from information_schema.routines where definer not like '%mysql%';
hope it helps!
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
