mysql setup issue

Wade Smart wadesmart at gmail.com
Fri Aug 24 09:08:22 UTC 2018


-- 
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.



More information about the ubuntu-users mailing list