Mysql error - phpmyadmin: Access denied!

Asked

Viewed 1,051 times

0

I have this problem with phpmyadmin, it was working normal, but when I typed: "mysql" in the linux shell it did not open mysql, only when typing: mysql -h 127.0.0.1 -P 3306 -u root.

Then I saw some articles and modified or deleted something from there giving this error:

#2002 - Arquivo ou diretório não encontrado — 
The server is not responding (or the local server's socket is not correctly configured).
mysqli_real_connect(): (HY000/2002): Arquivo ou diretório não encontrado
Connection for controluser as defined in your configuration failed.

Note: I only installed the xampp, then already came with mysql included, I’ve had this problem a made in Ubuntu do not remember how I solved, I’m using manjaro.

mysql database phpmyadmin xampp localhost
  • 1

    You didn’t install one on top of another ? I had this problem in Ubuntu, but I had installed two different versions unintentionally and one bugged the other

  • Hello, all good @Anthraxisbr? I don’t remember if I had installed mysql via manjaro, via Pacman. I’ll check this out, I had this problem also when using Ubuntu and it was almost that. Thank you so much for the tip.

1 answer

1


I found a similar mistake in Stackoverflow in English

He suggests changing localhost for 127.0.0.1 in the config.inc.php file (in XAMPP, this file must be in xampp/phpmyadmin/config.inc.php).

$cfg['Servers'][$i]['host'] = '127.0.0.1';

See if it helps.

  • 1

    Hello Cleber! Partner worked out this tip thank you so much. I had already seen it, but when I did this process had not worked out because this line of code was commented: //$cfg['Servers'][$i]['host'] = '127.0.0.1'; Soon when I removed the bars worked, it is the tip for someone else who has the same inattention as me. :)

  • Glad to help, Henrique! D

Browser other questions tagged mysql database phpmyadmin xampp localhost

You are not signed in. Login or sign up in order to post.