Re: [Warning] na inicialização do serviço
Fala Allan,
Na verdade tu está desabilitando a resolução de DNS mas tu ainda tem usuário com DNS no lugar do HOST, faz o seguinte:
1. Faz uma cópia de todos os usuários que tu tem, pode usar o pt-show-grants da percona toolkit.
2. Starta o MySQL sem o skip-name-resolve
3. Roda a seguinte query pra descobrir quais usuários tem DNS como host:
SELECT User, Host FROM mysql.user WHERE Host REGEXP '[a-z]' AND Host <> 'localhost';
4. Pra cada usuário que tu encontrar, roda um DROP USER user@host;
5. Quando tiver removido todos os usuário com DNS no host, adiciona o skip-name-resolve novamente e reinicia o MySQL.
Abs,
Marcelo Altmann
Subject
Views
Written By
Posted
1992
December 15, 2015 10:37AM
Re: [Warning] na inicialização do serviço
1174
December 15, 2015 11:42AM
1222
December 15, 2015 12:30PM
1194
December 15, 2015 01:36PM
1107
December 15, 2015 01:46PM
1057
December 15, 2015 02:02PM
1063
December 16, 2015 09:54AM
1193
December 16, 2015 09:57AM
1223
December 16, 2015 10:07AM
1040
December 17, 2015 12:08PM
981
December 21, 2015 04:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.