Skip to content

Instantly share code, notes, and snippets.

@luisalcarasr

luisalcarasr/.sql

Last active June 16, 2020 05:39
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save luisalcarasr/32f8dd15c32073be6e1d706829663f21 to your computer and use it in GitHub Desktop.
Save luisalcarasr/32f8dd15c32073be6e1d706829663f21 to your computer and use it in GitHub Desktop.
Download ZIP
Remove unix socket plugin from MariaDB 10
Raw
.sql
USE mysql;
UPDATE user SET plugin = "" WHERE user = "root";
UPDATE user SET password = PASSWORD("root") WHERE user = "root";
FLUSH PRIVILEGES;
@luisalcarasr
Copy link
Author

You can replace the PASSWORD function parameter by your password.

@luisalcarasr
Copy link
Author

luisalcarasr commented Jan 23, 2019 •
edited

If you have this error ERROR 1054 (42S22): Unknown column 'password' in 'field list' so execute:

UPDATE user SET authentication_string=PASSWORD("root") WHERE user="root";
UPDATE user SET plugin="mysql_native_password" WHERE User='root';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment