Root account can log in remotely

Description

The Root user is a high-privilege user that can perform any kind of operation on the system.

It is best practice to limit the access to this specific user only when connecting from local instances, and to eventually create another user with the specific DBA privileges, that will be able to connect from remote.

Resolution

Remove any root user that is not having ‘127.0.0.1’ or ‘localhost’ as host definition. Create a DBA user with the required privileges and specific for the schema that the DBA needs to handle.

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.