Re: Cannot remove MySQL completely

Axel Schwenke <[email protected]> Tue, 18 Jan 2022 10:44:47 +0100
Newsgroups comp.databases.mysql
Organization A noiseless patient Spider
Message-ID <[email protected]>
On 17.01.2022 17:57, pinnerite wrote:
> At the moment I can only get int MySQL from a root prompt. 
> Otherwise it asks for the root password which I have not set(?).

This is on purpose. Again: RTFM!

Read also the Debian README. Package maintainers often add extra $FOO to
packages. In the past Debian used to ask for a password for account name
'root' (which is traditionally the Superuser account). Now this is no longer
neccessary because socket authentication helps with identification of users.

Normally the first thing you do is create an account for yourself. If you
are connecting remotely (that means: the client is not running on the same
machines than the server) it includes setting a password.

And if you are running an application using the database (i.e. MythTV) then
it's highly recommended to create a MySQL account that is restricted to the
tables for that application.


XL