I have just gained access to a server with a hosting company which has mysql preinstalled. I've only used a server where I have installed mysql myself. On this server i can type mysql at the command line and it will open without needing a username or password. Looking at the mysql. users table there are several users including 2 root users (with different hosts, one is localhost and one is something else). I dont know the root passwords as I didn't create them.
Is it running in safe mode without password protection? If so, how do i tell?
Do i need to change the root password as described here?
i.e change the root password and then restart the service in normal mode?
Sorry for asking, I'm just a bit nervous about doing it
thanks in advance