Solve the problem of "ALTER USER" SQL query in MariaDB

Question

I am trying to execute a command in mysql console.

Change user "root"@"localhost" identified with mysql_native_password 'Password';

But I got this error.

There is an error in your SQL syntax; check the manual Corresponds to your MariaDB server version so that the correct syntax is used Line 1 near "BY 'pass'"

Version: 10.3.22-MariaDB-1ubuntu1 Ubuntu 20.04

Answer 1

ALTER USER 'root'@'localhost' IDENTIFIED BY 'pass';