mysql -- access with no user/passwd

[bruce]

Hi Robert,

Thanks on the reply,

I've set up mysql before with no issues. So I obviously missed
something when setting this up when I did.

The test has the "root" as well as other users and their passwords/access.

I did manage to reboot/rerun the cmd, and access is now denied if
passwd is not used.

weird..

On Sat, Jul 6, 2024 at 9:02 PM Robert Heller <heller at deepsoft.com> wrote:
>
> At Sat, 6 Jul 2024 20:44:36 -0400 "Ubuntu user technical support,? not for general discussions" <ubuntu-users at lists.ubuntu.com> wrote:
>
> >
> > Hi.
> >
> > Just realized. Set up a test mysql for 20.0.4 and I can access mysq
> > from the cmdline
> >
> >  mysql
> > allows access with no user/passwd
> >
> > Does anyone have pointers to disable this??
> >
> >  mysql_secure_installation
> >
> > doesn't seem to work from the cmdline/reboot.
>
> Define "doesn't seem to work".  Is the mysql_secure_installation command
> throwing an error? Or something else?
>
> The "bare" install of mysql-server (and mariadb-server) results in an nearly
> empty database with access with no user/passwd.  This is *normal* for a fresh
> install.  mysql_secure_installation is supposed to walk you through the
> process of cleaning out the demo data and setting up a root user with a
> password.  mysql_secure_installation should be part of a base install of
> mysql-server / mariadb-server and is a standard part of the post install
> process.
>
> >
> > thanks
> >
>
> --
> Robert Heller             -- Cell: 413-658-7953 GV: 978-633-5364
> Deepwoods Software        -- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> heller at deepsoft.com       -- Webhosting Services
>
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users