How to Replace the PASSWORD Function in MySQL 8.0 for Password Authentication?

The PASSWORD Function in MySQL Server 8.0

In MySQL Server version 8.0, the PASSWORD function behaves differently from previous versions. This may lead to errors when using the function, as shown in the question.

The error "Error Code: 1064. You have an error in your SQL syntax" indicates that the MySQL server is expecting a different syntax for the PASSWORD function. In previous versions of MySQL, the PASSWORD function was used to encrypt a password using the old password hashing algorithm. However, in MySQL 8.0, this algorithm has been deprecated and replaced with a more secure one.

To address this issue, the question provides a solution that involves using SHA1 and CONCAT functions to replace the PASSWORD function. The answer suggests using the following query as an alternative:

<code class="SQL">SELECT CONCAT('*', UPPER(SHA1(UNHEX(SHA1('mypass')))))</code>

This query concatenates an asterisk (*) with the uppercase hexadecimal representation of the SHA1 hash of the SHA1 hash of the input password ('mypass'). The result is similar to the output of the PASSWORD function in previous MySQL versions, making it a suitable replacement for authentication purposes.

The above is the detailed content of How to Replace the PASSWORD Function in MySQL 8.0 for Password Authentication?. For more information, please follow other related articles on the PHP Chinese website!