Share mysql databases between windows/linux partitions; ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded - Source

Revision: 99036
User: Dave Handler
Date: 2020-09-21 19:49

Hi!

I decided to do this little project because I got tired of updating two sets of identical databases on a dual boot system.  I love my Linux side and spent most of my time in it but at the same turn I still need windows as WINE just won't do everything.

After a very brief search that MySQL data is written in the same format across the two operating system I went on this adventure!
On windows I made a small NTFS partition to hold ONLY the database data.  On the Linux side I created a mount point and put the database data on that partition.

Now the Linux side works just fine!  I changed the data location in my.cnf and I can access that data just fine.

Windows is not playing nice!  When I try to access the mysql console ( mysql -u root -p ) I get the following error:
<<code>>ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded.<</code>>

I looked at the the error log and see this: 
<<code>>2020-06-07 22:04:06 0 [ERROR] mysqld.exe: Can't open shared library 'C:\Program Files\MariaDB 10.4\lib\plugin\auth_socket.so.dll' (errno: 2, The specified module could not be found.)<</code>>

There is no 'auth_socket.so.dll' which makes sense.

After some digging saw some hope by putting this line in the my.ini on windows ( skip-grant-tables ).  Understandably not a very safe thing to do.  This did allow me get access to the mysql console.  I ran a query update the root password to what I uses.  I then remove the skip-grant-tables from the my.ini file and this error 1524 reappears.  Note: yes I am stopping and starting the service with every change of the ini file.

Not really sure what to do at this point.
Any help I am greatly appreciative for!
Dave

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Share mysql databases between windows/linux partitions; ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB