antiblock
https://i.imgur.com/aJ17bf7.gif
  • Chatbox

    You don't have permission to chat.
    Load More
  • 0
andrezinho00780

[Ajuda] MySQL 55 Serv metin2

Question

Boas a todos estou com um problema em configurar meu FreeBSD 9.2 - 9.3 (ambos apresentam o mesmo erro)

 Configuro tudo certinho o mysql coloco na configuração

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha123' WITH GRANT OPTION; 
 
GRANT ALL PRIVILEGES ON *.* TO 'maxmi'@'localhost' IDENTIFIED BY 'blackforce--' WITH GRANT OPTION;

 

então dou quit e reinicio a maquina, após tentar logar no sistema através do navicat o mesmo apresenta o mesmo erro alguém sabe como resolver?

 

access denied for user 'root'@'localhost' (using password =  yes)

Share this post


Link to post
Share on other sites

3 answers to this question

  • 0

tens de ir ver a senha e o Id que tens no ficheiro config e mudar no user:  'root'@'localhost'   do navicat

Share this post


Link to post
Share on other sites
antiblock
Elveron
  • 0
grant all privileges on *.* TO 'root'@'localhost';
grant all privileges on *.* TO 'maxmi'@'%';
flush privileges;
quit;
'root'@'localhost'; <!-- Apenas o localhost pode aceder a esta conta. -->
'maxmi'@'%'; <!-- % Qualquer IP pode aceder a esta conta. -->

Navicat

Host: IP

Port: 3306

Username: maxmi

Password: ****

Máquina

$ mysql -u root -p

Password: ****

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now