MySQL - debian-sys-maint account

[eggroid]

I zapped the debian-sys-maint account right out of MySql doing a restore from a different distro - what permissions do I need to give this account?

Can anybody with MySql try this:

SHOW GRANTS for 'debian-sys-maint'@'localhost';

Thank you!

[eggroid]

bump!

Can somebody with mysql server installed help me out here?

[eggroid]

SOLVED

I did it myself by booting up a Live CD.

mysql> show grants for 'debian-sys-maint'@'localhost';
+---------------------------------------------------------------------------------------------------------------------------+
| Grants for debian-sys-maint@localhost                                             |
+---------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '1c26de472d9b41cf' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------------------+

The strikes me as a little to much access though... I set it to:

GRANT RELOAD, SHUTDOWN, PROCESS, SHOW DATABASES, SUPER, LOCK TABLES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '1c26de472d9b41cf'

At first glance this seems like enough to rotate the logs out. But the default, for anybody else having the same problem, is all privileges on *.*, as above.

[mediajunkie]

Hi,

I have the same thing (loaded a dump from other server) and now I get :/etc/init.d$ /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

I've tried:

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '1c26de472d9b41cf' WITH GRANT OPTION

but with no result. I still get the same error on restarting.
Is there any way to recover out of this?

thanks

[Kochin]

Find your debian-sys-maint password in /etc/mysql/debian.cnf.

Then use

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '<password>' WITH GRANT OPTION;

Replace <password> with your debian-sys-maint password.

[Abhi Kalyan]

Am a new person here and am learling posting here as this thread interests my current Project.
Thank you

[satimis]

Hi folks,

Ubuntu-6.06.1-LAMP-server-amd64
MySQL - Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (x86_64) using readline 5.1


I have the same problem on restarting MySQL

$ sudo /etc/init.d/mysql restart
Password:

Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
satimis@ubuntu:~$ /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

(the cursor hanging here.  I suppose waiting for input)

mysql> show grants for 'debian-sys-maint'@'localhost';

ERROR 1141 (42000): There is no such grant defined for user 'debian-sys-maint' on host 'localhost'

/etc/mysql/debian.cnf is an empty file.

Please advise what shall I do? How to fix it? TIA


B.R.
satimis

[hogman23]

Originally Posted by satimis mysql> show grants for 'debian-sys-maint'@'localhost'; ERROR 1141 (42000): There is no such grant defined for user 'debian-sys-maint' on host 'localhost' /etc/mysql/debian.cnf is an empty file. Please advise what shall I do? How to fix it? TIA B.R. satimis

I would add something like this in the file:


# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = tdsclIL73xUw2ip2
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user = debian-sys-maint
password = tdsclIL73xUw2ip2
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

[satimis]

Hi hogman23,

Tks for your advice.

I haven't touched mysql sometimes. Strangely I found;

$ cat /etc/mysql/debian.cnf

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = qsN2OSgfrhI6AFzG
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = qsN2OSgfrhI6AFzG
socket   = /var/run/mysqld/mysqld.sock

It is now not an empty file.

What are those "password = qsN2OSgfrhI6AFzG"? Tks.

B.R.
satimis

[matsti]

I had the same problem after an upgrade (I use Debian and apt). A new password was generated in /etc/mysql/debian.cnf but my existing mysql DB kept the password configuration as before the upgrade. Overwriting the password (qsN2OSgfrhI6AFzG in previous post) with my mysql password from before the upgrade did the trick. Hope this helps. M