Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Working with Views, Stored Procedures and Triggers: I have full privileges to a database but cannot ALTER a routine. Why?

April 26, 2017database privileges routine stored procedures triggers working

0

Posted

Working with Views, Stored Procedures and Triggers: I have full privileges to a database but cannot ALTER a routine. Why?

1 Answer

0

Posted

You experience that you have full privileges to a database (described in GRANT syntax like GRANT ALL PRIVILEGES ON some_database.* TO ‘me’@’somehost’) but cannot ALTER … • About the SQLyog program » General Use: How can I run SQLyog from a portable drive. Answer: With a normal installation SQLyog will (since version 6.06) not write its configuration file (‘SQLyog.ini’) as well as the ‘favorites’ folder and the local SQLite …