Procedures (Create & Alter) WARN Functions (Create & Alter) WARN

  • Resolved hommealone

    (@hommealone)


    2 years ago

    I’m curious about a WARN notice I got during the validation step of installation:

    TABLE PRIVILEGES ON [our_new_dbname]
Create PASS
Select PASS
Insert PASS
Update PASS
Delete PASS
Drop PASS
Procedures (Create & Alter) WARN
Functions (Create & Alter) WARN

    When I created the new DB user via cPanel, I selected “All Privileges”.

    When I asked the hosting company (A2 Hosting) about this message, they said to go ahead and try the install anyway, which I did – successfully.

    I’m wondering though… what exactly are the “Procedures” and “Functions” privileges? What do they allow the user to do, and what are they needed for?

    If they are needed, why are they not granted when I select “All Privileges” during DB User creation via cPanel?

    Also… I searched through the Duplicator online documentation, but couldn’t find info about this notice; did I miss something? If not, perhaps a note in there might be helpful?

    Any explanations appreciated, thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support devdavidam

    (@devdavidam)

    @hommealone you can find more information about stored procedures here (stored functions are similar to procedures):

    https://www.w3schools.com/sql/sql_stored_procedures.asp
    https://www.techtarget.com/searchoracle/definition/stored-procedure

    As you can see from the definition, those are statements which are stored in the database and can be reused by multiple programs. WordPress itself doesn’t use this functionality, and I’m not aware of any plugin using this as well. So, in most cases, migrating a website without those privileges runs fine. However, if you have created any procedures or functions yourself or use any plugins which do so, then you would need those privileges to fully migrate the database and create the functions and procedures automatically.

    Regarding the question of why those privileges are not granted when “All Privileges” is selected, I think this is question should be answered by the hosting provider.

    Thread Starter hommealone

    (@hommealone)

    Thanks very much! I appreciate the explanation.

    Since this notification may come up during installation from a duplicator package, and many of the users are not knowledgeable about these things, I’d suggest that a note in your documentation might be a helpful addition. ?? It would keep us from worrying and searching fruitlessly to figure out what – if anything – is going wrong.

    Thanks again for making the Duplicator plugin available on the WP repository, and your help in the forum!!

    Plugin Support devdavidam

    (@devdavidam)

    Thanks, @hommealone we will take your comments in consideration.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Procedures (Create & Alter) WARN Functions (Create & Alter) WARN’ is closed to new replies.