mariadb ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client
#SQLTools - VSCode err: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MariaDB client sudo mysql -u root MariaDB [(none)]> update mysql.user set password=password('<yourpassword>') where user='root'; MariaDB [(none)]> flush privileges; ------------------------------------------------------------- sudo mysql -u root -p Enter password: ******* select user,host,password,plugin from mysql.user; output: +------+-----------+------------------------+-------------+ | user | host | password | plugin | +------+-----------+------------------------+-------------+ | root | localhost | ***************** | unix_socket | | root | e320 | ***************** | unix_socket | | root | 127.0.0.1 | ***************** | unix_socket | | root | ::1 | ***************** | unix_socket | +------+-----------+------------------------+-------------+ ------------------------------------------------------------- sudo mysql -u root -p Enter password: ******* update mysql.user set plugin='' where user='root'; flush privileges;
