How to fix?: mysql> show variables like 'plugin_dir'; Does not show plugin_dir location

Question

After this post I continued to try to setup MySQL memcached User-Defined Functions as per these instructions: http://stanley-huang.blogspot.com/2010/04/level-3-install-memcached-user-defined.html

But now when trying to find the plugin_dir location I get:

mysql> show variables like 'plugin_dir';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| plugin_dir    |       | 
+---------------+-------+
1 row in set (0.00 sec)

It's blank. What did I miss?

Thanks

score 3 · Accepted Answer · answered Aug 09 '12 at 20:55

3

Check your my.cnf

[mysqld]
plugin_dir=/path/to/plugin/directory

answered Aug 09 '12 at 20:55

mattl

539
4
10

There's none set in my.cnf Safe to set one? – Hayden Aug 09 '12 at 20:57
@mattl My sysadmin has done this for me, but the `plugin_dir` variable is still blank. Any ideas? – jmilloy Aug 25 '12 at 16:41

Mohammad Gabr · Answer 2 · 2023-07-14T16:18:20.170

0

I think you might be looking for this:

select @@plugin_dir;

edited Jul 14 '23 at 16:18

answered Jul 08 '23 at 15:54

Mohammad Gabr

1
1

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 11 '23 at 06:44

How to fix?: mysql> show variables like 'plugin_dir'; Does not show plugin_dir location

2 Answers2