https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18852 --- Comment #2 from C.J.S. Hayward <CJSH@CJSHayward.com> ---
From a mailing list response, after things are working:
-- Tim Young <Tim.Young@lightsys.org> 8:56 PM (17 hours ago) to koha Hi, This sounds like it is because of an odd "feature" of mysql which is not always present. This page: https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-no... with the answer from "Todor", explains that mysql will change over to using an auth_socket "plugin." So, instead of using password authentication, part of the permission is blocked by unix file-level permissions. The simple solution: sudo mysql -u root update mysql.user set plugin = 'mysql_native_password' where User='root'; FLUSH PRIVILEGES; Then you should be able to connect up as root even if you are not a root user. After that, you should be able to run the script. - Tim -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.