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
Comments
No Comments »
Categories
Ubuntu/Debian
Comments rss Comments rss
Trackback Trackback

 

December 2008
M T W T F S S
« Oct   Jan »
1234567
891011121314
15161718192021
22232425262728
293031  

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