CODEWITHSUNDEEP
mysqlmariadb
djangoscholar
djangoscholar

Reputation: 133

Alter Statement Working in MySQl but not in MAriaDB?

Why does not this statment work in Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64), but works in MySQL?

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

Error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MyPassword';

Thanks.

Upvotes: 0

Views: 2977

Answers (1)

Rahul
Rahul

Reputation: 77876

The ALTER USER statement was introduced in MariaDB 10.2.0 (You are in 10.1.29) and that's the issue here. See https://mariadb.com/kb/en/library/error-1604/

Upvotes: 5

Related Questions