Background: im hosting dolibarr locally on win 10 IIS, and originally setup mysql community 8 (latest as of post date). However after setting up everything Dolibarr can’t connect to mysql as the root account, because i believe Dolibarr still uses native password and not the new sha256 passwords. fixed that now cant get the dolibarr mysql account to connect.
Im not sure if this is still an issue, or i just too much of a newbie, but after hours of debugging i found that dolibarr can’t create a new user in mysql due to mysql depreciating the one liner way of adding and granting privileges, and requiring to create and then grant privileges to the user. So my question is was anyone able to use Dolibarr with mysql 8+ ?
