On 05/07/2017 09:25 AM, Dick Steffens wrote: > On 05/07/2017 05:45 AM, Richard Owlett wrote: >> On 05/06/2017 04:05 PM, Dick Steffens wrote: >>> <...> >>> >> This is my comment I mentioned above - "root" can mean to many >> things. Above, when I thought mysql now ran, I was logged into >> Debian as root - not as richard. >> As Debian's root user "mysql - u root" alone will run. >> Also "mysql - u root -p<cr>" will prompt for a password and will >> run if what was entered for "MySQL application password for >> phpmyadmin" is given *BUT NOT* for a "bad" password. >> >> I can't pursue this at the moment. >> It will have to wait till this afternoon. > > Yes, root has more than one use. It can lead to confusion for awhile. > In general, a "system" needs an administrative user, often named > root. The confusion comes from there being more than one "system" in > a system. > There's the operating system, which is the one we usually think of. > But then there's the database system. And while the same name can be > used, it bears no relation to the operating system user root. > You could name one Fred and the other Ethel, or you could name both > of them Fred and get the same results. (At least I think you could > name the OS root user Fred. I'm not sure about that. I know you could > name the DB administrative user Fred.) To be safe, and have other > folks know what you're talking about, it's probably safest to stick > with root for both, as long as you understand that they are in a > different context. >
Keeping context clear is the sticky point. I have decided that the character string "root" shall uniquely refer to the OS. I've seen that somewhere in the documentation I've read in last couple of months. Wish I kept a better list of what I read and especially those that were useful ;/ Today's task is to create sets of "administrator" and "end user" name/password pairs. Have several links. The one I attempted to follow didn't work. Operator error or author error? ???? ;/ _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
