node.js - 尝试在 MariaDB shell 中重置 Root 密码时出现语法错误

Question

我已经在 Linux Ubuntu 18.04 上新安装了 MariaDB-server(10.1.34)

我已经启动了一个 SQL shell:

sudo -i
mysql -uroot -p -h localhost

外壳打开。我想更改我的密码以与 Node.js typeorm 和 mysql 驱动程序兼容(因为我总是得到这个 error )，如下所示:

ALTER USER root@localhost IDENTIFIED BY '12345';

它总是说我的语法有错误，但我在线检查，它甚至在 MariaDBs ALTER USER site 上也有。 。这里出了什么问题？我尝试过:

ALTER USER root@localhost IDENTIFIED BY '12345';
ALTER USER 'root'@'localhost' IDENTIFIED BY '12345';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345';
ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY '12345';
ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '12345';

但是没有任何作用。我总是遇到语法错误，但我不知道我在哪里犯了错误。有人可以指出我的错误吗？

Answer 1

来自https://mariadb.com/kb/en/library/alter-user/ :

The ALTER USER statement was introduced in MariaDB 10.2.0.

另请参阅旧版SET PASSWORD:https://mariadb.com/kb/en/library/set-password/