Mysql Error 1126 Windows
Reporter: Roel Van de Paar (OCA) Email Updates: Status: Closed Impact on me: None Category:MySQL Server: User-defined functions ( UDF ) Severity:S2 (Serious) Version:5.0, 5.1.28 OS:Microsoft Windows Assigned to: Kristofer Pettersson Tags: Contribution, regression Triage: Triaged: D4 (Minor) View Add Comment Files Developer Edit Submission View Progress Log Contributions [17 Jun 2009 7:10] Roel Van de Paar Description: Several issues seen: o mysqld adds a '/' to the plugin_dir o mysqld adds '/plugin' to the plugin_dir when not specified in my.ini o '/' does not seem to work correctly ('/' and '\\' should work instead of '\' which is not allowed in syntax) 5.1.31 tests: ----------------------- No setting for plugin_dir in my.ini mysql> show variables like '%plug%'; +---------------+---------------------------+ | Variable_name | Value | +---------------+---------------------------+ | plugin_dir | C:\mysql5.1.31\lib/plugin | +---------------+---------------------------+ 1 row in set (0.00 sec) mysql> INSTALL PLUGIN lib_mysqludf_xql SONAME 'lib_mysqludf_xql.dll'; ERROR 1126 (HY000): Can't open shared library 'C:\mysql5.1.31\lib/plugin/lib_mysqludf_xql.dll' (errno: 2 ) ----------------------- plugin_dir="C:/mysql5.1.31/lib/plugin" in my.ini mysql> INSTALL PLUGIN lib_mysqludf_xql SONAME 'lib_mysqludf_xql.dll'; ERROR 1126 (HY000): Can't open shared library 'C:/mysql5.1.31/lib/plugin/lib_mysqludf_xql.dll' (errno: 2 ) ----------------------- plugin_dir="C:\\mysql5.1.31\\lib\\plugin\\" in my.ini mysql> INSTALL PLUGIN lib_mysqludf_xql SONAME 'lib_mysqludf_xql.dll'; ERROR 1126 (HY000): Can't open shared library 'C:\mysql5.1.31\lib\plugin\/lib_mysqludf_xql.dll' (errno: 2 ) ----------------------- plugin_dir="C:\\mysql5.1.31\\lib\\plugin" in my.ini iirc mysql> INSTALL PLUGIN lib_mysqludf_xql SONAME 'lib_mysqludf_xql.dll'; ERROR 1126 (HY000): Can't open shared library 'C:\mysql5.1.31\lib\plugin/lib_mysqludf_xql.dll' (errno: 2 ) ----------------------- plugin_dir="C:" in my.ini mysql> INSTALL PLUGIN lib_mysqludf_xql SONAME 'lib_mysqludf_xql.dll'; ERROR 1126 (HY000): Can't open shared library 'C:/lib_mysqludf_xql.dll' (errno:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join https://bugs.mysql.com/bug.php?id=45549 the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR 1126 (HY000): Can't open shared library 'lib_mysqludf_sys.so' (errno: 193 ) up vote 0 down vote favorite I am using MySQL http://stackoverflow.com/questions/28642274/error-1126-hy000-cant-open-shared-library-lib-mysqludf-sys-so-errno-193 5.6.11 running on 32-bit Microsoft Windows XP (Professional Version 2002 Service Pack 3). I am interested in installing the MySQL sys_exec UDF. The following command, mysql> SHOW VARIABLES LIKE 'plugin_dir'; shows the following plugin location. +---------------+-----------------------------------------------------+ | Variable_name | Value | +---------------+-----------------------------------------------------+ | plugin_dir | C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\ | +---------------+-----------------------------------------------------+ Where I pasted lib_mysqludf_sys.so. Then running the following command, CREATE FUNCTION sys_exec RETURNS INT SONAME 'lib_mysqludf_sys.so'; from the MySQL command line results in the following error (after login has been made into the root user and an already created database has been selected). ERROR 1126 (HY000): Can't open shared library 'lib_mysqludf_sys.so' (errno: 193 ) How to fix this error? Is msvcp110.dll needed under C:\WINDOWS\system32? It is not available there. The file msvcp100.dll is however, located under C:\WINDOWS\system32. mysql mysql-5.6 mysql-udf share|improve this question asked Feb 21 '15 at 4:57 Tiny 5,24252191349 'lib_mysqludf_sys.so' i
Sign in Pricing Blog Support Search GitHub This repository Watch 5 Star 8 Fork 8 mysqludf/lib_mysqludf_str forked from dtrebbien/lib_mysqludf_str https://github.com/mysqludf/lib_mysqludf_str/blob/master/README.win_x86.txt Code Issues 0 Pull requests 0 Projects 0 Pulse Graphs Permalink Branch: master Switch branches/tags Branches Tags downloads master Nothing to show v0.5 v0.4 v0.3 v0.2_2 v0.2 Nothing to show Find file Copy path lib_mysqludf_str/README.win_x86.txt 4b5c038 Feb 2, 2014 dtrebbien Add information to the READMEs 1 contributor Users who have contributed to this file dtrebbien mysql error Raw Blame History 96 lines (66 sloc) 4.03 KB This is a build of version 0.5 of lib_mysqludf_str for 32-bit MySQL 5.1+ and Windows XP SP3 or later. It is licensed under the terms of the LGPL version 2.1 or later, the exact text of which is located in COPYING. All source code for this mysql error 1126 project is downloadable from GitHub: https://github.com/mysqludf/lib_mysqludf_str/ INSTALLATION ================================================================================ To install the lib_mysqludf_str UDFs: 1. Make sure that you have installed the 32-bit build of MySQL 5.1 or later. Note: The lib_mysqludf_str.dll binary has only been tested with MySQL version 5.6, but should work with MySQL 5.5, 5.1 and 5.0 as well. It is, however, incompatible with MySQL 3.23/4.0/4.1. 2. Look for a file named msvcr110.dll in your System32 folder (on a 64-bit Windows machine, look for this file in the SysWOW64 folder instead). If this file is not present, then install the latest Visual C++ Redistributable for Visual Studio 2012 vcredist_x86.exe: http://www.microsoft.com/en-us/download/details.aspx?id=30679 3. Copy lib_mysqludf_str.dll to the MySQL installation's lib\plugin folder. With a default installation, this is C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\ Note: You do NOT need to re-start MySQL after copying lib_mysqludf_str.dll into the plugin directory. 4. As root, source installdb.win.sql or simply paste the contents into the CLI client. 5. Test the setup by executing: SELECT lib_mysqludf_str_info() FROM DUAL; The result