Elevation of permission after mysql5.1

Source: Internet
Author: User

MYSQL 5.1 and later versions have another limit. The DLL used to create a function can only be placed in the plugin directory of mysql .. This plug-in directory does not exist by default .. YD: it may be to prevent the DLL from being written to this folder through into dumpfile .. MYSQL cannot create a directory. If the target directory of into dumpfile does not exist, an error is returned. It needs to be created manually, but it is a system variable. I installed MYSQL 5.1.3 on the Virtual Machine for testing. The installation directory is: C: \ Program Files \ MySQL Server 5.1. You can see: show variables like '% plugin %: + ------------------------------- + values | Variable_name | Value + ----------------------------------- + values | plugin_dir | C: \ Program Files \ MySQL Server 5.1 \ Lib/plugin + --------------------------------- + the plug-in directory is located in the lib/plugin directory of the mysql installation directory, which needs to be created manually. Upload udf. dll to this location and create a function. However, the value of this variable is read-only. An error occurs when you try to use set @ plugin_dir = 'd: \ '; to change its value. You can modify this value only by modifying php. ini and adding a plugin_dir = d:/in it.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.