Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I've changed my server OS to Ubuntu, which comes with a 'debian-sys-maint' SQL user when you install MySQL.

Now the problem: If you don't have the user or it's got "insufficient" permissions, you will get a warning message. Tutorials around the web show granting "ALL" permissions to the given MySQL user.

I don't think that's a good security move.
What permissions does that user really needs?

share|improve this question
up vote 0 down vote accepted

If you already have root@localhost (which has all privileges activated), then having that user would be kind of redundant. It would only be of use if you logged into mysql on that machine using DNS. That's unnecessary because root@localhost will connect to mysql via a socket file.

If would OK to just remove that user.

Once you log into mysql as root@localhost you can remove that user with this:

DELETE FROM mysql.user WHERE user='debian-sys-maint';
FLUSH PRIVILEGES;

For further information on what grants there are for users, check out the MySQL Documentation on User Grants.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .