Gentoo Blog

The ultimate Gentoo Blog
  • Home
  • About

Lost your debian-sys-maint account?

Simon | December 8, 2008

This has happend to me a few times. You import a mysql user database from another server and you get these horrible errors when you restart mysql.

error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Go find your debian-sys-maint password in

/etc/mysql/debian.cnf

Write it down you will need it later. Log on to your mysql server and issue the following command

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

Change your-password with the password from the file debian.cnf. I am sure the debian-sys-maint user could be given less rights but this thread is only helping to restore the previous defaults. So please be aware this could be a security issue.

Share on Facebook
Categories
Ubuntu/Debian
Comments rss
Comments rss
Trackback
Trackback

« Another Intrepid Ibex Counter just to make sure we don’t forget :) German Umlaut on Debian Console »

Leave a Reply

Click here to cancel reply.

 

February 2012
M T W T F S S
« Dec    
 12345
6789101112
13141516171819
20212223242526
272829  

Categories

  • confixx/Plesk
  • fun
  • Gentoo
  • iptables
  • mysql
  • news
  • Raid Controllers
  • Stuff
  • Ubuntu/Debian
  • Xen/Vmware

Links

  • Gentoo
  • http.net
  • iphone software linux
  • michael-fuchs.net
  • Ubuntu
  • webupd8.org

Search Blog

rss Comments rss valid xhtml 1.1 design by jide powered by Wordpress get firefox