Why doesn't the PASSWORD function work in MySQL Ver 8.0.11?

Question

MySQL

CentOS 7, trying to install MySQL server. Added a repository from the MySQL website, installed, installed the version

# mysqld --version
/usr/sbin/mysqld  Ver 8.0.11 for Linux on x86_64 (MySQL Community Server - GPL)

I didn’t want to enter without a password, the standard ones don’t roll either. I tried to change, but the PASSWORD function gives an error:

mysql> SELECT PASSWORD('test');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('test')' at line 1

What am I doing wrong?

Answer 1

https://dev.mysql.com/doc/refman/8.0/en/encryption...
https://dev.mysql.com/doc/refman/8.0/en/user-accou...