mysql -- access with no user/passwd

[Robert Heller]

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