I tried logging in to my MySQL server remotely and suddenly, this error appear. MySQL error code 1524. I didn’t know what it means and I am freaking out because I could lose all my data. So I did a quick google search and luckily I found a solution and save my database.
So here is what I did.
First I tried logging in to my MySQL server remotely like this.
mysql -u [username] -p[password] -h x.x.x.x ERROR 1524 (HY000): Plugin '[some-random-hash]' is not loaded
So what happened is apparently my user table has corrupted and I don’t know the reason why.
If this happened to you. Here is what you can do to fix it.
Login to your actual server and then login to your MySQL server from there.
mysql -u [username] -p[password]
Now that you are logged in, Update the user table of your mysql database by issuing this command.
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = '[username]';
After issuing that command, you need to flush privileges.
This simple commands should resolve the issue. If not, please comment below and let’s try to resolve it. 🙂