CODEWITHSUNDEEP
mysqlmariadbghost-blog
Widdles
Widdles

Reputation: 163

Why isn't this SQL statement working? Is it a problem with my MariaDB server?

This has been a frustrating issue. On my Linux machine (hold up, don't transfer me to AskUbuntu yet), I install my MariaDB server (sudo apt install mysql-server), and login with sudo mysql -uroot -p,and type in my password. Here's the weird part. I enter in my statement, which is below.

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

At which point I get the standard 'please check the docs that correspond with your MariaDB server', which I am sure drives every programmer insane at some point. The bigger issue is, this statement is recorded in official documentation for a service I am using. Any help is greatly appreciated. If there is a problem with my statement, please let me know.

Upvotes: 1

Views: 134

Answers (1)

Ortomala Lokni
Ortomala Lokni

Reputation: 62635

As stated in the documentation:

The ALTER USER statement was introduced in MariaDB 10.2.0.

Upgrade to a version equals or higher to 10.2.0 and the problem will be solved.

Upvotes: 1

Related Questions