MSQL Error on Login Fresh Install

[mychri...@gmail.com]

Fresh install of 3.4. I found a couple other posts but nothing matched.

Install and config went with no errors, setup went ok. Then initial login with admin/admin

threw this Sql error.

PHP 7.4.3

MySQL 8.0.30 on Ubunto 20.04

Could my MySQL be too new?

An error occured in function '': 'mysql query failed'
Error occured in 'login.inc.php' at line '263'
Additional info: '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 '('admin') OR `passwd`=MD5('admin') OR `passwd`=MD5('admin')) LIMIT 1' at line 3'

Check your MySQL connection and if the problem persist, contact the author.
Execution stopped.

[Arnie Shore]

You're probably right on that too-new MySQL guess.  I don't see the MD5 function included in anything newer than MySQL 5.7

AS

--
You received this message because you are subscribed to the Google Groups "Open Source CAD" group.
To unsubscribe from this group and stop receiving emails from it, send an email to open-source-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/open-source-cad/eff0894b-d810-4241-9607-4731f392b3bdn%40googlegroups.com.

[David Russell]

I can confirm this is the case. Nothing past MySQL 5.7.

[jms.comp...@gmail.com]

I found this link that documents, sha, sha1, sha2 and md5 for mySql 8.0 - https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html  

Which seems to be the next version after 5.7  But I do not spent a lot of time in mySQL so I may be mistaken..  

Also might check out this search of the 8.0 documentation - https://dev.mysql.com/doc/search/?d=201&p=1&q=MD5%28%29

I think you have some other issue and it may be related to defaults for login - https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

"For the server, the default value of the default_authentication_plugin system variable changes from mysql_native_password to caching_sha2_password."