MySQL Plugin Error – Ubuntu Cannot Open Shared Library mysqlx.so

MySQLmysql-5.7pluginsUbuntu

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?

Best Answer

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.