[Koha-bugs] [Bug 18852] Installation is inoperative even after fresh install

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18852

--- Comment #2 from C.J.S. Hayward <CJSH at CJSHayward.com> ---
>From a mailing list response, after things are working:

--

Tim Young <Tim.Young at 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-normal-user-account-in-ubuntu-16-04

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.