PHPMyAdmin EDIT and EXECUTE Buttons Disabled for Stored Procedures

I created a couple of stored procedures in a remote MySql (web) database a week ago ... during the session where I created them, I was able to edit, export them, etc.

Now, after a week, I wanted to edit them, and found that the Edit and Execute buttons on the Routines tab for these two were disabled ...

tab

My web server is running phpmyadmin 4.0.10.7

I found out that for some reason in the ROUTINES table in the INFORMATION_SCHEMA db file these procedures (procedures) have a different DEFINITION (well, not different, but db considers them different)

Definitions for Procedures

... , , . CPanel PHPMyAdmin, , , DEFINER - user@icario.servidoraweb.net( + - -)... , , , ( SELECT CURRENT_USER();) "user@10.0.5.47"...

-, , CPanel IP- , , , .

, , , , "user @icaro..."

, , "user@10.0..."

... , ... , , - , , IP-.

?

+4

Source: https://habr.com/ru/post/1627096/


All Articles