Syntax Error when trying to reset Root password in MariaDB shell

Question

I have installed MariaDB-server(10.1.34) freshly on Linux Ubuntu 18.04

I have started a SQL shell with:

sudo -i
mysql -uroot -p -h localhost

The shell opens. I want to change my password to be compatible with Node.js typeorm and mysql driver(as I always get this error) with the following:

ALTER USER root@localhost IDENTIFIED BY '12345';

And it always says I have an error in my syntax but I checked online and it's even on MariaDBs ALTER USER site. What is going wrong here? I tried:

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';

But nothing works. I always get a syntax error, but I don't know where I made a mistake. Can someone point out my mistake?

Rick James · Accepted Answer · 2019-02-05 00:23:22Z

0

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

The ALTER USER statement was introduced in MariaDB 10.2.0.

See also the older SET PASSWORD: https://mariadb.com/kb/en/library/set-password/

answered Feb 5, 2019 at 0:23

Rick James

144k15 gold badges144 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error when trying to reset Root password in MariaDB shell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related