I'm trying to setup and use "User Defined Functions" (UDF) in MySQL. First of all, typing: show variables like 'plugin'; in order to get the mysql plugin path returns an empty result set for me. I tried specifying the plugin directory directly in my.cnf, under [mysqld], by adding: plugin_dir=/usr/lib/mysql (note: i created the above directory and chown'ed it to mysql:mysql). After that MySQL could not restart any more.
Looking in syslog, I found the following: Jul 25 10:29:09 gx200 mysqld_safe[14480]: started Jul 25 10:29:09 gx200 mysqld[14483]: 070725 10:29:09 [ERROR] /usr/sbin/mysqld: unknown variable 'plugin_dir=/usr/lib/mysql' Jul 25 10:29:09 gx200 mysqld[14483]: Jul 25 10:29:09 gx200 mysqld_safe[14485]: ended I'm using debian etch. Thanks for any help. ____________________________________________________________________________________ Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]