Creating the debian-sys-maint MySQL account on a Debian or Ubuntu system
Submitted by specialj on Thu, 2008-03-13 02:02.
I was working on a server running MySQL and found that the debian-sys-maint account not longer existed which caused errors when upgrading the mysql packages. It was relatively simple to fix by getting the password from the /etc/mysql/debian.cnf file and running the following command:
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password';
In this case the word password is replaced by the value in the /etc/mysql/debian.cnf file.
Trackback URL for this post:
http://hightechsorcery.com/trackback/90
I'd say that this is not
I'd say that this is not secure, as you're likely granting privileges that are too wide.
Why insecure? Root can get
Why insecure? Root can get at your data anyway. And if this file is only readable by root...