+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
+---- Thread: v18 MySQL database create error caching sha2 password could not be loaded (/showthread.php?tid=346332)
MySQL database create error caching sha2 password could not be loaded - dougski - 2019-08-16
I built a new Kodi setup and installed MySQl 8.0. I set the authentication mode to Legacy when configuring MySQL. I get the following error in the kodi.log file using Leia 18.3.
2019-08-16 01:16:06.036 T:9888 ERROR: Unable to open database: MusicLeia72 [2059](Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'lib/mariadb/plugin/caching_sha2_password.dll')
My old Kodi setup which i upgraded to Leia 18.3 is working fine with MySQL 5.7.
What am I missing? Does Kodi support MySQL 8.0 ?
RE: MySQL database create error caching sha2 password could not be loaded - Andreas737 - 2019-09-18
(2019-08-16, 08:39)dougski Wrote: I built a new Kodi setup and installed MySQl 8.0. I set the authentication mode to Legacy when configuring MySQL. I get the following error in the kodi.log file using Leia 18.3.
2019-08-16 01:16:06.036 T:9888 ERROR: Unable to open database: MusicLeia72 [2059](Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'lib/mariadb/plugin/caching_sha2_password.dll')
My old Kodi setup which i upgraded to Leia 18.3 is working fine with MySQL 5.7.
What am I missing? Does Kodi support MySQL 8.0 ?
I had the same error message. Could solve it by changing the identification method to "mysql_native_password" like below:
CREATE USER 'nativeuser'@localhost IDENTIFIED WITH mysql_native_password BY 'password';
RE: MySQL database create error caching sha2 password could not be loaded - dougski - 2019-09-18
(2019-08-16, 08:39)dougski Wrote: I built a new Kodi setup and installed MySQl 8.0. I set the authentication mode to Legacy when configuring MySQL. I get the following error in the kodi.log file using Leia 18.3.I went through the configuration for MySQL 8.0 a few times and rebooted the machine and it fixed the problem. I think somehow the configuration option to use the legacy password option in My SQL 8.0 was not taking effect before which caused the error.
2019-08-16 01:16:06.036 T:9888 ERROR: Unable to open database: MusicLeia72 [2059](Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'lib/mariadb/plugin/caching_sha2_password.dll')
My old Kodi setup which i upgraded to Leia 18.3 is working fine with MySQL 5.7.
What am I missing? Does Kodi support MySQL 8.0 ?
RE: MySQL database create error caching sha2 password could not be loaded - dr-oopie - 2020-03-27
i was able to fix it by dropping the user i used for kodi and remade it with the following:
CREATE USER 'username'@'localhost'IDENTIFIED WITH mysql_native_password BY 'userpassword';