• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Electric Toolbox Blog

The Electric Toolbox Blog

Linux, Apache, Nginx, MySQL, Javascript and PHP articles

  • Applications
  • FCKEditor
  • Apache
  • Windows
  • Contact Us
Home / Article / MySql / How to restore the debian-sys-maint MySQL user

How to restore the debian-sys-maint MySQL user

My last post looked at how to fix ERROR 1045 (28000): Access denied for user ‘debian-sys-maint’@’localhost’ on MySQL and this article shows how to restore the debian-sys-maint user if you’ve accidentally deleted it. I accidentally deleted the user myself when I reset a MySQL database using the /usr/bin/mysql_install_db script.

The SQL Query

Log into MySQL as the root user and run the following SQL query, substituting PASSWORD-HERE for the actual plain text password which is the same as the password in the /etc/mysql/debian.conf file:

INSERT INTO `user` (
	 `Host`,
	 `User`,
	 `Password`,
	 `Select_priv`,
	 `Insert_priv`,
	 `Update_priv`,
	 `Delete_priv`,
	 `Create_priv`,
	 `Drop_priv`,
	 `Reload_priv`,
	 `Shutdown_priv`,
	 `Process_priv`,
	 `File_priv`,
	 `Grant_priv`,
	 `References_priv`,
	 `Index_priv`,
	 `Alter_priv`,
	 `Show_db_priv`,
	 `Super_priv`,
	 `Create_tmp_table_priv`,
	 `Lock_tables_priv`,
	 `Execute_priv`,
	 `Repl_slave_priv`,
	 `Repl_client_priv`,
	 `Create_view_priv`,
	 `Show_view_priv`,
	 `Create_routine_priv`,
	 `Alter_routine_priv`,
	 `Create_user_priv`,
	 `ssl_type`,
	 `ssl_cipher`,
	 `x509_issuer`,
	 `x509_subject`,
	 `max_questions`,
	 `max_updates`,
	 `max_connections`,
	 `max_user_connections`
 )
 VALUES (
	 'localhost',
	 'debian-sys-maint',
	 password('PASSWORD-HERE'),
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'Y',
	 'N',
	 'N',
	 'N',
	 'N',
	 'N',
	 '',
	 '',
	 '',
	 '',
	 0,
	 0,
	 0,
	 0
	 );
 FLUSH PRIVILEGES;

 And that’s all there is to it. 

Check Out These Related posts:

  1. jQuery: show plain text in a password field and then make it a regular password field on focus
  2. MySQL Query Cache
  3. ERROR 1045 (28000): Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)
  4. Restore data from a tab delimited file to MySQL

Filed Under: MySql

Primary Sidebar

Categories

  • Apache
  • Applications
  • Article
  • Case Studies
  • Email Servers
  • FCKEditor
  • HTML And CSS
  • Javascript
  • Linux/Unix/BSD
  • Microsoft SQL Server
  • Miscellaneous Postings
  • MySql
  • Networking
  • Nginx Web Server
  • Offsite Articles
  • OSX
  • PHP
  • Quick Tips
  • RFC – Request for Comments
  • SilverStripe
  • VMWare
  • VPN
  • Windows
  • WordPress

Recent Posts

  • Vim Show Line Numbers
  • Add User To Group Linux
  • Chmod 777 Tutorial
  • How to Copy Directory Linux
  • Linux create user

Copyright © 2021. ElectricToolBox. All Rights Reserved.

  • Contact Us
  • Copyright Info
  • Privacy Policy
  • Sitemap