MySQL Root Account

[Roger Oberholtzer]

On Tue, 2005-02-08 at 06:42, James McDonald wrote:
> On Mon, Feb 07, 2005 at 09:52:39PM -0500, Kurt Wall wrote:
> > I'm looking for opinions, which I know most of people on this list have. 
> > By default, the MySQL administrative account (the one with superuser 
> > privileges in MySQL), is named "root." This seems like a really 
> > unfortunate choice of names, in that the system superuser account is 
> > likewise named "root." I'm thinking of changing it to something more 
> > reasonable, like "dba" or "admin." It seems like a good idea to me, but 
> > I'm open to other opinions.
> 
> Isn't the reason for this so that the default mysql login name is pulled from the USER env var?
> 
> I have frequently got confused by the fact that you have two roots on a system with possibly wildly differnt passwords or worse yet the same password.

I thought it was just me. I HATE installing some web software that
sloppily asks for various MySQL passwords. I am never sure what they
want. After trial and error I eventually sort it out. 

And why do I have 2 root passwords? One on the machine name and one on
localhost. Different root passwords depending on which interface you
connect to the same server? Or?

+????????????????????????????+???????????????????????????????+
? Roger Oberholtzer          ?   E-mail: roger at opq.se        ?
? OPQ Systems AB             ?      WWW: http://www.opq.se/  ?
? Nybrogatan 66 nb           ?    Phone: Int + 46 8   314223 ?
? 114 41 Stockholm           ?   Mobile: Int + 46 733 621657 ?
? Sweden                     ?      Fax: Int + 46 8   314223 ?
+????????????????????????????+???????????????????????????????+