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
2001
December 15, 2015 10:37AM
Re: [Warning] na inicialização do serviço
1180
December 15, 2015 11:42AM
1230
December 15, 2015 12:30PM
1200
December 15, 2015 01:36PM
1112
December 15, 2015 01:46PM
1061
December 15, 2015 02:02PM
1069
December 16, 2015 09:54AM
1198
December 16, 2015 09:57AM
1227
December 16, 2015 10:07AM
1046
December 17, 2015 12:08PM
988
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.