MySQL Root Account

[A. Khattri]

On Tue, 8 Feb 2005, Roger Oberholtzer wrote:

> I am sure it is. But I always wonder what 'state' MySQL is in when it is
> installed by various distros. Is there a root user? One for each
> interface? Is there a password set yet? I think this comes from me not
> using it enough.

There is a root user and it has no password but for good reason.

Normally, when installing manually, one has to run a script
("mysql_install_db") to setup the initial mysql tables. Once this script
has been run you then create a separate superuser account and lock the
root account and never use it again (you could delete the root account at
that point I suppose).

If you are upgrading MySQL you never have to run this install script so it
isn't an issue. (Im assuming RPMs do this setup for you when installing
for the first time).


--