Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012

    Unanswered: Not able to edit SP in shared hosting using workbench

    hello all,
    We are using a web application using PHP + MySQL, and hosting is done in shared hosting services. The DB queries are written using Stored Procedure(SP). WHile creating the SP, we used to login to the phpmyadmin and create the SP by pasting the query create procedure in the SQL query command window. All works fine, no issue

    Now we want to use the workbench to do editing the SP, for checking the diff of the schema and all. Here our problem starts, workbench is not able to show me or edit the SP, its not able to get the data. all the tables we are able to access.

    After debugging, got help from the hosting provider, they told since the SP is created using phpmyadmin, the definer in taht is so only through this we can edit it.

    my queries are as below

    1) How can i change all the SP to be editable from my PC through workbench and take advantage of the schema compare feature , where my IP address also changes (Dynamic IP for internet connection)

    Some one can trough some light on this, will be very helpful

    Thanks for the support

  2. #2
    Join Date
    Mar 2004
    That is something you'd have to ask your host.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts