Solve the problem of "ALTER USER" SQL query in MariaDB
P粉908138620
2023-08-26 09:07:12
<p>I am trying to execute a command in mysql console. </p>
<blockquote>
<p>Change user "root"@"localhost" identified with mysql_native_password
'Password';</p>
</blockquote>
<p>But I got this error. </p>
<blockquote>
<p>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'"</p>
</blockquote>
<p>Version: 10.3.22-MariaDB-1ubuntu1 Ubuntu 20.04</p>
Like +0
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
