mysql setup issue

[Colin Law]

On Fri, 24 Aug 2018 at 10:10, Wade Smart <wadesmart at gmail.com> wrote:
>
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
> On Fri, Aug 24, 2018 at 2:31 AM Colin Law <clanlaw at gmail.com> wrote:
> >
> > 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
>
> I was reading something I had found in another forum that said the same thing.
> It did work with all caps.

It isn't so much the caps as whether you needed the
WITH mysql_native_password

That wasn't in my first post.

Colin