Share mysql databases between windows/linux partitions; ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
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:
ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded.
I looked at the the error log and see this:
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.)
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 Answered by Daniel Black in this comment.
Like this answer:
Did you use `ALTER USER` to change the user plugin and password? You should of.