Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
If MariaDB reports ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded, the account is configured to use an authentication plugin that the server has not loaded. On Ubuntu and Debian packages, the usual repair—if the plugin library is installed—is to connect as the local operating-system root user and run INSTALL SONAME 'auth_socket';. The account plugin is named unix_socket, but its shared library is commonly named auth_socket.so.
What the error means
MariaDB error 1524 means that a requested plugin is not loaded; it does not, by itself, mean the database is corrupt or that you entered the wrong password. In this case, an account is configured for unix_socket authentication, but MariaDB cannot use that plugin. MariaDB defines error 1524 as “Plugin %s is not loaded.”
With Unix-socket authentication, MariaDB checks the operating-system identity associated with a local socket connection. For example, the OS user root can generally connect as the MariaDB account 'root'@'localhost' without a database password. MariaDB documents the plugin’s behavior and installation.
Keep the two names straight: unix_socket is the authentication plugin name stored on the account; Ubuntu and Debian packages commonly provide it in the auth_socket.so library. That is why the usual SQL command names auth_socket, not unix_socket. MariaDB describes the Debian and Ubuntu packaging difference.
#1 Best Overall
- 【4 Ports USB 3.0 Hub】Acer USB Hub extends your device with 4 additional USB 3.0 ports, ideal for connecting USB peripherals such as flash drive, mouse, keyboard, printer
- 【5Gbps Data Transfer】The USB splitter is designed with 4 USB 3.0 data ports, you can transfer movies, photos, and files in seconds at speed up to 5Gbps. When connecting hard drives to transfer files, you need to power the hub through the 5V USB C port to ensure stable and fast data transmission
- 【Excellent Technical Design】Build-in advanced GL3510 chip with good thermal design, keeping your devices and data safe. Plug and play, no driver needed, supporting 4 ports to work simultaneously to improve your work efficiency
- 【Portable Design】Acer multiport USB adapter is slim and lightweight with a 2ft cable, making it easy to put into bag or briefcase with your laptop while traveling and business trips. LED light can clearly tell you whether it works or not
- 【Wide Compatibility】Crafted with a high-quality housing for enhanced durability and heat dissipation, this USB-A expansion is compatible with Acer, XPS, PS4, Xbox, Laptops, and works on macOS, Windows, ChromeOS, Linux
Try the normal repair first
This path applies when MariaDB is running, the plugin library is available to the server, and you can connect locally with administrative privileges.
-
Check the service:
sudo systemctl status mariadb. MariaDB’s systemd unit is normallymariadb.serviceon systemd-managed installations. If it is stopped, start it withsudo systemctl start mariadb. If it will not start, inspectsudo journalctl -xeu mariadbbefore changing authentication. See MariaDB’s systemd service guidance. -
Try a local administrative connection:
sudo mariadb. Depending on installed client commands,sudo mysqlmay also work. Thesudomatters: socket authentication sees the OS identity of the client process, so runningmariadb -u root -pas an ordinary user is not equivalent.Recommended: Crashes or Glitches? A Free Driver Scan Usually Finds the Culprit →Recommended: PC Feels Slow? A Free Scan Shows What's Dragging Windows Down →Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
In the MariaDB prompt, check whether the plugin is loaded and where MariaDB expects plugin libraries:
SHOW PLUGINS; SHOW VARIABLES LIKE 'plugin_dir'; -
If
unix_socketis absent and you have confirmed this is the Ubuntu/Debian package library, load it:INSTALL SONAME 'auth_socket';Do not substitute
INSTALL SONAME 'unix_socket'on the assumption that the account plugin and library have the same name. INSTALL SONAME loads valid plugins from a shared library in MariaDB’s plugin directory.Rank #2
Sale
Anker USB Hub, 4-in-1 USB Splitter, 4 USB-A Ports with 5Gbps Data Transfer- The Anker Advantage: Join the 80 million+ powered by our leading technology.
- SuperSpeed Data: Sync data at blazing speeds up to 5Gbps—fast enough to transfer an HD movie in seconds.
- Big Expansion: Transform one of your computer's USB ports into four. (This hub is not designed to charge devices.)
- Extra Tough: Precision-designed for heat resistance and incredible durability.
- What You Get: Anker Ultra Slim 4-Port USB 3.0 Data Hub, welcome guide, our worry-free 18-month warranty and friendly customer service.
-
Verify it, then test a fresh local login:
SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY FROM information_schema.PLUGINS WHERE PLUGIN_NAME IN ('unix_socket', 'auth_socket');The
unix_socketrow should show an active status. Exit withexit, then runsudo mariadbagain.Recommended Free Tools
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Current MariaDB versions and new Ubuntu/Debian .deb installations commonly include this plugin, but older builds, custom installations, disabled-plugin settings, and package mismatches can differ. MariaDB’s authentication overview and MariaDB 10.4-and-later authentication notes describe the Linux socket-authentication model; package source and version still matter.
Inspect the account and connection before changing authentication
If you can connect, inspect the account’s actual definition rather than assuming that a password reset is the answer:
SELECT User, Host, plugin
FROM mysql.user;
SHOW CREATE USER 'root'@'localhost';SHOW CREATE USER gives the account definition to use when checking its authentication method. MariaDB documents it alongside ALTER USER for account management. The presentation of mysql.user.plugin can vary across MariaDB versions, so do not rely on that column alone.
Also confirm what kind of connection the failing client makes. localhost commonly selects a Unix socket, while 127.0.0.1 requests TCP; accounts such as 'appuser'@'localhost' and 'appuser'@'127.0.0.1' are separate host matches. Test the same route the application uses:
mariadb -u appuser -p
mariadb -h localhost -u appuser -p
mariadb -h 127.0.0.1 -u appuser -pA Unix-socket plugin is not a general TCP password method. If an application uses TCP, create or configure the account for the appropriate host and authentication method; avoid broad host patterns unless they are genuinely needed.
Rank #3
- 4 USB Ports Expansion: This USB Hub turns 1 USB A port into 4 USB A ports with your devices for mouses, keyboards, U disks, flash drives, and more USB Peripherals. Greatly improve your work efficiency
- Transfer Files in Seconds: The USB 3.0 Hub supports a max file transfer speed of 5Gbps. That's fast enough to transfer a 10 GB file in just 16.4 seconds
- Plug and Play: No additional drivers or software are required. The USB multiport adapter is plug-and-play for Windows, macOS, Linux, Chrome OS, and More
- Wide Compatibility: In addition to laptops and desktop computers, this USB 3.0 splitter also supports other devices with USB A such as Xbox Series, PS5, car systems, etc., which can meet the various needs of your daily life
- Compact Mini Size: This USB A hub is designed to be very compact and portable, which is only 0.4 inches thick and 33g heavy. It is very suitable for your travel and business trips
If the plugin library is missing or will not load
First compare MariaDB’s reported plugin_dir with the system’s library files. From the shell, search likely library locations:
sudo find /usr/lib /usr/lib64 -type f -name 'auth_socket.so' 2>/dev/nullIf the file exists but INSTALL SONAME fails, check the MariaDB error log, verify that plugin_dir points to the directory containing the file, and check for packages mixed across repositories or versions. Do not copy auth_socket.so from another MariaDB version, Ubuntu release, or MySQL installation; plugin binaries need to match the server installation.
If the library is absent, confirm which server and package source are installed before repairing packages:
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →mariadb --version
apt-cache policy mariadb-serverPackage names, dependencies, and layouts may differ between Ubuntu’s MariaDB packages and MariaDB’s own repository packages. If the installed package is the one you intend to use, a package repair may restore its missing files:
sudo apt update
sudo apt install --reinstall mariadb-server mariadb-client
sudo systemctl restart mariadbThen retry sudo mariadb and the plugin check. Reinstalling packages is not the same as deleting the database, but do not purge packages or remove /var/lib/mysql as a troubleshooting shortcut. Take a tested backup before any operation that could affect the data directory.
Choose socket or password authentication deliberately
Keep socket authentication for local administration
For a server administered through SSH by OS administrators, retaining socket authentication for 'root'@'localhost' avoids storing a database root password and keeps OS-level privileges as the gate. This is generally the better choice when the error is only that the plugin is unavailable and applications can use separate database accounts. Socket access is intentionally less convenient for GUI clients, remote logins, and applications that cannot connect as the relevant operating-system user.
Rank #4
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Switch an account to password authentication only when a client needs it
If a legacy installer or client specifically requires password-based login, MariaDB supports changing the account’s method to mysql_native_password and setting a password as separate steps:
Free tools Windows power users keep installed
One-click scans. No signup required.
ALTER USER 'root'@'localhost'
IDENTIFIED VIA mysql_native_password;
SET PASSWORD = PASSWORD('replace-with-a-strong-unique-password');Then test the intended connection:
mariadb -u root -p
mariadb -h 127.0.0.1 -u root -pDo not assume that SET PASSWORD by itself changes the account’s authentication plugin. Changing the method can also break scripts or client configurations that rely on passwordless socket access. Use this route only if the compatibility need outweighs the cost of maintaining a privileged password.
Prefer a separate account for an application
For WordPress, PHP, or another application, keep MariaDB root for administration and give the application its own account with only the privileges it needs. For example:
CREATE USER 'appuser'@'localhost'
IDENTIFIED BY 'use-a-long-unique-password';
GRANT SELECT, INSERT, UPDATE, DELETE
ON app_database.* TO 'appuser'@'localhost';Replace the database, username, and password with values appropriate to the installation, and match the account host to the application’s actual connection path. A separate database administrator can be created when needed, but do not grant an application ALL PRIVILEGES ON *.*. MariaDB’s connection troubleshooting guidance discusses account setup for client connections.
Emergency recovery when no administrative login works
Use this only after checking the service, trying the local socket connection, and investigating whether the plugin library or package is missing. Recovery with skip-grant-tables bypasses normal privilege checks; exact service overrides and option-file paths vary with the MariaDB package and Ubuntu release, so inspect the active service and configuration before applying a temporary setup.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
-
Take a backup or a suitable storage snapshot before changing the server’s recovery configuration.
Best Value
USB Hub 7 Port, USB Splitter with Individual On/Off Switches and Lights.- [7-Port USB 3.0 Hub] ONFINIO USB hub turns one USB port into Seven, support for USB Flash drive, Mouse, Keyboard, Printer, or any other USB Peripherals. And it's backward compatible with your older USB 2.0 / 1.0 devices.
- [5Gbps Data Transfer Speed] This USB hub splitter 3.0 syncs data at blazing speeds up to 5Gbps, which is more than 10 times faster than USB 2.0, fast enough to transfer an HD movie in seconds.
- [Easy to Use] This USB port hub has a built-in high-performance chip to keep your devices and data safe, and supports hot swapping. No need for installation of any software, drivers, plug and play. Please offer extra power supply when the power-hungry devices are connected.
- [Compact & Portable] The USB extension cable multiple port has been intelligently designed to be as slim and light as possible, ideal for your working and traveling with ultrabook. Exquisite gift box packaging, easy to store and use.
- [Wide Compatibility] ONFINIO usb hub for laptop is compatible with Windows 10/8/8.1/7 / Vista / XP and Mac OS X, Linux, and Chrome OS. USB expander applies to various devices: laptop, pc , XBOX, PS4, flash drive, printer, mouse, card reader, HDD, keyboard, camera, console, USB fan.
-
Stop the normal service:
sudo systemctl stop mariadb. -
Start a temporary local recovery instance using
skip-grant-tablesandskip-networking. Use the package’s documented service/configuration mechanism and ensure the normal server is not running concurrently against the same data directory. -
Connect locally, run
FLUSH PRIVILEGES;, and then either load the available plugin withINSTALL SONAME 'auth_socket';or repair the affected account’s authentication method.Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Stop the temporary instance and remove the temporary recovery settings. Do not leave
skip-grant-tablesenabled. -
Start MariaDB normally and test the expected local and application connections. Confirm that ordinary privilege enforcement and networking are restored.
MariaDB documents systemd service behavior, but there is no single recovery command sequence that safely fits every Ubuntu package layout. Consult the active unit and configuration rather than copying an option-file path from a different release.
Quick Recap
Match the symptom to the next check
| Symptom | Likely issue | Next check |
|---|---|---|
Plugin 'unix_socket' is not loaded |
The account names an authentication plugin that is absent or disabled. | Check SHOW PLUGINS and plugin_dir; if the package library is present, run INSTALL SONAME 'auth_socket';. |
Access denied when using a password |
The account may expect socket authentication, or the supplied credentials may not match its account definition. | Try sudo mariadb for local OS-root access and inspect SHOW CREATE USER if you can connect. |
| Cannot connect through the local socket | The service may be stopped, or the client may be using a different socket path. | Check systemctl status mariadb, the journal, and MariaDB’s socket setting. |
Works with localhost but fails with 127.0.0.1 |
Socket versus TCP transport or a different account host match. | Test the intended transport and check the corresponding 'user'@'host' account. |
auth_socket.so cannot be found |
The library may be missing, the plugin directory may be wrong, or packages may be mismatched. | Check plugin_dir, MariaDB version, package source, and server logs; repair the matching package if needed. |
INSTALL SONAME fails despite a file being present |
Wrong plugin directory, incompatible library, or a load error reported by the server. | Read the MariaDB error log and verify the library matches the installed server; do not substitute a binary from another installation. |
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errors
