Linux, MySQL

How to restore debian-sys-maint MySQL Maria user

I had an issue where I wiped this user out accidentally in a galera cluster on Ubuntu 14.04. This is how to add ‘debian-sys-maint’@’localhost’ user back into your MySQL server and then enjoy all the ‘benefits’ once more..

You can then verify the user with SELECT * from mysql.user\G

Make sure that the password in /etc/mysql/debian.conf matches the password below as THE_PASSWORD.

use mysql;
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('THE_PASSWORD'),
	'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;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s