In MySQL SERVER 8.0 the PASSWORD function not working

by

If you need a replacement hash to match the password() function, use this: SHA1(UNHEX(SHA1()));

E.g.

mysql> SELECT PASSWORD('mypass');
+-------------------------------------------+
| PASSWORD('mypass')                        |
+-------------------------------------------+
| *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4 |
+-------------------------------------------+

and replacement that gives the same answer in version 8:

mysql> SELECT CONCAT('*', UPPER(SHA1(UNHEX(SHA1('mypass')))));
+-------------------------------------------------+
| CONCAT('*', UPPER(SHA1(UNHEX(SHA1('mypass'))))) |
+-------------------------------------------------+
| *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4       |
+-------------------------------------------------+

More Related Contents:

  1. How do you use the “WITH” clause in MySQL?
  2. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  3. How to grant all privileges to root user in MySQL 8.0
  4. phpMyAdmin on MySQL 8.0 [duplicate]
  5. Node.js can’t authenticate to MySQL 8.0
  6. MySQL search json value by key in array
  7. mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
  8. How to group by two rows in a column
  9. How can I output MySQL query results in CSV format?
  10. How to perform grouped ranking in MySQL
  11. How to abort INSERT operation in MySql trigger?
  12. Converting a date in MySQL from string field
  13. Mysql or/and precedence?
  14. CHECK constraint in MySQL is not working
  15. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  16. Which is more efficient: Multiple MySQL tables or one large table?
  17. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  18. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  19. MySQL InnoDB foreign key between different databases
  20. Replace Into Query Syntax
  21. Loading utf-8 encoded text into MySQL table
  22. Ruby gem mysql2 install failing [duplicate]
  23. How to schedule a stored procedure in MySQL
  24. What’s the best way to migrate a Django DB from SQLite to MySQL?
  25. How to import a SQL Server .bak file into MySQL?
  26. MySQL: Insert datetime into other datetime field
  27. Import CSV to Update rows in table
  28. Why in SQL NULL can’t match with NULL?
  29. Invoke pusher when mysql has changed [closed]
  30. Summing a comma separated column in MySQL 4 (not 5)

Leave a Comment