Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I recently received a warning from MySQL that stated:

[Warning] 'proxies_priv' entry '@ root@serverdomain' ignored in --skip-name-resolve mode.

I looked in mysql.proxies_priv and there is definitely an entry for "serverdomain", however there is no user with "@serverdomain". Documentation on this is very sparse, this is all I could find.

How do I remove this entry and how was it ever created?

share|improve this question

Given the link from your question, look at the table mysql.proxies_priv

mysql> show create table mysql.proxies_priv\G
*************************** 1. row ***************************
       Table: proxies_priv
Create Table: CREATE TABLE `proxies_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges'
1 row in set (0.00 sec)


Since it is a MyISAM table, you could just truncate the table.

In case you need it back, make a backup of it and truncate it after.

ALTER TABLE mysql.proxies_priv RENAME mysql.proxies_priv_backup;
CREATE TABLE mysql.proxies_priv LIKE mysql.proxies_priv_backup;

Then, go restart mysql

service mysql restart

A far simpler way would be to use the REVOKE command:

    FROM user [, user] ...

Due to the warning, you would have to restart mysql to make sure the warning does not come back.

Give it a Try !!!

share|improve this answer
I have not done this yet, but will sure to comment/accept. – Carson Reinke Feb 10 '14 at 13:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.