[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

mySQL root user password



Hello list:

 

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:

 

User

Hosts

Encrypted password

Permissions

debian-sys-maint

localhost

xxxxxxxxxxxxxxxxxx

Reload | Shutdown

User1

192.168.1.5

xxxxxxxxxxxxxxxxxx

None

root

localhost

xxxxxxxxxxxxxxxxxx

All

root

ZEUS.MYDOMAIN.LOCAL

 

All

 

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?

 

Thanx!


Reply to: