Rocky, apache et MySql

Rocky Linux Help & Support
1

Bonjour tous,

J’ai installé Apache et je continue.
Mot de passe pour mysql

[root@vmxxx ~]# mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.3.28-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

créer un mot de passe

MariaDB [(none)]> ALTER USER ‘root’@‘localhost’ identified by ‘123456’;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> ALTER USER ‘root’@‘localhost’ PASSWORD EXPIRE NEVER;
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 ‘PASSWORD EXPIRE NEVER’ at line 1
MariaDB [(none)]> exit

Si je tape Enter, je reviens sous [root@vmxxx ~]#
Mais pourquoi cette erreur ?
J’ai essayé \q au lieu de exit, c’est pareil ?
Comment je fais pour fermer .