Skip to content

mysqli::real_connect(): (HY000/2002): Permission denied #16516

@zkelo

Description

@zkelo

Describe the bug

When I try to login with correct login and password I'm getting an following error: mysqli::real_connect(): (HY000/2002): Permission denied

To Reproduce

(0. Setup phpMyAdmin;)

  1. Open phpMyAdmin;
  2. Enter correct login and password;
  3. Press "Go" button.

Expected behavior

I successfully login as entered user and can see databases and can do something with them.

Screenshots

image

Server configuration

  • Operating system: CentOS 8
  • Web server: nginx/1.18.0
  • Database version: mysql Ver 8.0.22 for Linux on x86_64 (MySQL Community Server - GPL)
  • PHP version: PHP 7.4.13 (cli) (built: Nov 24 2020 10:03:34) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.13, Copyright (c), by Zend Technologies
  • phpMyAdmin version: 5.0.4

Client configuration

  • Browser: Chrome 87.0.4280.88
  • Operating system: Windows 10 Home Single Language

Additional context

Described error happens with this setting's value: $cfg['Servers'][$i]['host'] = 'localhost';. When I changing value of this setting to 127.0.0.1 instead of localhost and entering with correct login and password nothing happens (just reloads page)

Metadata

Metadata

Assignees

Labels

questionUsed when we need feedback from the submitter or when the issue is a question about PMA

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions