MySQL Bugs: #113579: provide sample SQL syntax in docs for plugin-loading.html

Bug #113579	provide sample SQL syntax in docs for plugin-loading.html
Submitted:	8 Jan 2024 13:50	Modified:	2 Feb 2024 22:04
Reporter:	Simon Mudd (OCA)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html does not provide examples of the SQL syntax to use to load or unload plugins.  This information is provided elsewhere but not obviously referred to on this page.

Given the page title describes the various uses it would seem sensible to include a simple example of loading the plugin with SQL syntax or unloading a plugin with the syntax to use so that we don't have to go and find the syntax elsewhere. This saves time.

How to repeat:
Check the web page, where there are references for use with the my.cnf configuration but not for the SQL invocation to load or unload a plugin.

Suggested fix:
Fix as described above.

Hi Mr. Mudd,

Thank you for your documentation request.

We find it entirely necessary.

This affects version 8.0 and all higher versions, as well.

Verified as described.

https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html#server-plugin-installing-insta... shows the syntax.

In addition, nearly every instance of "INSTALL PLUGIN" or "UNINSTALL PLUGIN" on that page is a link to the appropriate Syntax page. 

Not sure why this was missed previously, but it's there.

Thank you, Jon.