Skip to content

Instantly share code, notes, and snippets.

@mul14

mul14/switch_to_mysql_native_password.md

Forked from rohsyl/switch_to_mysql_native_password.md
Created January 18, 2022 10:33
Show Gist options
  • Save mul14/226cc013bc7a2470d7d856f91c1753f1 to your computer and use it in GitHub Desktop.
Save mul14/226cc013bc7a2470d7d856f91c1753f1 to your computer and use it in GitHub Desktop.
Download ZIP
MariaDB switch to mysql_native_password
Raw
switch_to_mysql_native_password.md

Switch to mysql_native_password plugin

By default MariaDB use the unix_socket plugin to authenticate users.

But it's easier to use mysql_native_password for dev (and only for dev because it's way less secure).

Get root access

sudo su

Connect to mysql

mysql

Run this query

update mysql.user set plugin = 'mysql_native_password' where User = 'root';

And then

flush privileges;

Enjoy !

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