Hello,
Since 23 december 2021 the MySQL 8.0 instance (with Moodle database) has crashed. I tried upgrading essential software and fixing the problem with the encrypted database-user password, that now is mandatory for MySQL and PHP. So, Moodle platform has to deal with this security restriction, when using newer versions of MySQL and PHP.
1. MySQL Notifier 1.1.8 shows that the MySQL 8.0 instance has stopped. I cannot start it up again.
2. The DBMS HeidiSQL will not connect to MySQL 8.0.27 anymore.
3. MySQL Workbench 8.0 CE of Oracle will now open an empty workbench (‘No connection established’).
4. The Command Line Client: MySQL 8.0 now hangs and then crashes when trying to login (clear password) to MySQL 8.0.
5. Thus, I cannot run the instruction "ALTER USER 'moodleuser'@'localhost' IDENTIFIED with mysql_native_password BY '***'"
6. So, I guess I have to re-install MySQL instance.
a) How can I uninstall the MySQL 8.0 instance?
b) Should I relentlessly delete everything in the following folders?
C:\Program Files\MySQL\MySQL Server 8.0
C:\Program Files\MySQL\MySQL Shell 8.0
C:\ProgramData\MySQL\MySQL Server 8.0
c) Can I then reinstall the version 8.0.27 of MySQL via MySQL Installer 1.6 ?
d) Will such an operation only affect the MySQL 8.0 service and not the relevant 8.0 databases (Moodle, Matomo) nor MySQL 5.7 service?
e) Or is a corrupted password stored inside the databases?
f) Is the encrypted password stored in a MySQL 8 system-database or client-database?
When I get MySQL 8 up and running again (with encrypted connection), then I will upgrade PHP to version 7.4 (supporting caching_sha2_password).
Any help will be appreciated.
Friendly regards,
Rolf
Environment:
Windows 10 pro, IIS 10, Moodle 3.8.1+ , PHP 7.2.8 , MySQL 8.0.27