I just finished an installation of mySQL, I am trying to manage the SQL server from the Webmin module for mysql. As soon as I finished the installation I remembered to set the root password for the mySQL server however, I went to the Webmin module to see what users were existent and this is what I saw:
How come I have 2 root users? Do I need them both? And how can I set the password for the root user that has no password currently. The ZEUS.MYDOMAIN.LOCAL host is the computer where I installed mySQL to, in other words it is the computer that I am accessing. And as you can see it has all the same permissions as the root user from the localhost Host. I know that I use the first root user whenever I am accessing the mySQL server locally, however when would I use the second root account that accesses the mySQL server from ZEUS.MYDOMAIN.LOCAL? since Zeus is the computer where mySQL is installed isn’t that the same thing as accessing fomr localhost? SO do I really need that second root user account?