mysql setup issue

[Colin Law]

On Thu, 23 Aug 2018 at 22:26, Wade Smart <wadesmart at gmail.com> wrote:
>
> On Thu, Aug 23, 2018 at 3:58 PM Colin Law <clanlaw at gmail.com> wrote:
> > ...
> > This is the technique I found
> > sudo -i
> > mysql
> > alter user 'root'@'localhost' identified by 'thepassword';
> > bye
> > exit
> >
> > Colin
>
> Thanks Colin.

Did that work? Having looked at my notes again I see I actually had to do
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY
'mypassword';

There was a thread about this a couple of months ago
https://lists.ubuntu.com/archives/ubuntu-users/2018-July/294296.html

Colin



>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users