1

MySQL Server version:

Ubuntu: 5.7.23-0ubuntu0.18.04.1-log (Ubuntu)

MySQL installed using apt-get.

When installing a plugin with the following command:

mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';

...I receive the following error message:

ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/mysqlx.so' (errno: 2 /usr/lib/mysql/plugin/mysqlx.so: cannot open shared object file: No such file or directory)

What can't Ubuntu locate/find the mysqlx.so library?

2 Answers 2

1

Three comments:

One: Maybe you are using 'mysqlx.so; and you forgot the closing " ' "

I mean please use 'mysqlx.so' in stead of 'mysqlx.so

Two: We expect to find the file mysqlx.so in the that /usr/lib/mysql/plugin/.

Is the file mysqlx.so in than path /usr/lib/mysql/plugin/

Three: If so, maybe you have to check if the file mysqlx.so has full permissions for the user that controls mysql.

1
  • Comment One: That is typo. Comment Two: mysqlx.so is not present in Ubuntu (but present in macos).
    – vishnu
    Aug 8, 2018 at 4:29
1

Note: By default ubuntu-18.04 apt-get package does not include mysqlx.so plugin file, but macOS mysql-server installation contains mysqlx.so by default.

How to enable mysqlx.so?

Run the following command in mysql> console to know whether mysqlx.so is installed or not:

mysql> SHOW PLUGINS\G

By default, 'mysqlx' will not present in the list. To enable it execute the following (for more info click here),

mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';

Output:
...
*************************** 45. row ***************************
   Name: mysqlx
 Status: ACTIVE
   Type: DAEMON
Library: mysqlx.so
License: GPL
...

In my case it is not listed in the output. (Now read the initial problem posted my me)

ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/mysqlx.so' (errno: 2 /usr/lib/mysql/plugin/mysqlx.so: cannot open shared object file: No such file or directory)

My Solution is hard path: Build mysql-server-5.7 from the source (providing all the dependencies)

After the Post installation Setup for mysql-server, execute the following commands in mysql> console:

mysql> INSTALL PLUGIN mysqlx SONAME 'mysqlx.so';
mysql> SHOW PLUGINS\G

Output:
...
*************************** 45. row ***************************
   Name: mysqlx
 Status: ACTIVE
   Type: DAEMON
Library: mysqlx.so
License: GPL
...

Additional info: Then installed mysql-shell and python-connector (for my case)

Shell and connector are required for X DevAPI (X Protocol) programming.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.