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

Answer 1

I think you might be looking for this:

select @@plugin_dir;

Answer 2

Check your my.cnf

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