In phpMyAdmin 4 before 4.9.4 and 5 before 5.0.1, SQL injection exists in the user accounts page. A malicious user could inject custom SQL in place of their own username when creating queries to this page. An attacker must have a valid MySQL account to access the server.

The remote Ubuntu 16.04 ESM / 18.04 ESM / 20.04 ESM host has a package installed that is affected by multiple vulnerabilities as referenced in the USN-4843-1 advisory.

  - libraries/common.inc.php in phpMyAdmin 4.0.x before 4.0.10.7, 4.1.x before 4.1.14.8, and 4.2.x before     4.2.13.1 allows remote attackers to cause a denial of service (resource consumption) via a long password.
    (CVE-2014-9218)

  - An issue was discovered in phpMyAdmin. A specially crafted database name could be used to run arbitrary     PHP commands through the array export feature. All 4.6.x versions (prior to 4.6.4), 4.4.x versions (prior     to 4.4.15.8), and 4.0.x versions (prior to 4.0.10.17) are affected. (CVE-2016-6609)

  - An issue was discovered in phpMyAdmin. In the user interface preference feature, a user can execute an SQL     injection attack against the account of the control user. All 4.6.x versions (prior to 4.6.4), 4.4.x     versions (prior to 4.4.15.8), and 4.0.x versions (prior to 4.0.10.17) are affected. (CVE-2016-6619)

  - An issue was discovered in phpMyAdmin. An authenticated user can trigger a denial-of-service (DoS) attack     by entering a very long password at the change password dialog. All 4.6.x versions (prior to 4.6.4), 4.4.x     versions (prior to 4.4.15.8), and 4.0.x versions (prior to 4.0.10.17) are affected. (CVE-2016-6630)

  - An issue was discovered in phpMyAdmin. It is possible to bypass AllowRoot restriction     ($cfg['Servers'][$i]['AllowRoot']) and deny rules for username by using Null Byte in the username. All     4.6.x versions (prior to 4.6.5), 4.4.x versions (prior to 4.4.15.9), and 4.0.x versions (prior to     4.0.10.18) are affected. (CVE-2016-9849)

  - An issue was discovered in phpMyAdmin. When the arg_separator is different from its default & value, the     CSRF token was not properly stripped from the return URL of the preference import action. All 4.6.x     versions (prior to 4.6.5), 4.4.x versions (prior to 4.4.15.9), and 4.0.x versions (prior to 4.0.10.18) are     affected. (CVE-2016-9866)

  - An issue was discovered in libraries/common.inc.php in phpMyAdmin 4.0 before 4.0.10.20, 4.4.x, 4.6.x, and     4.7.0 prereleases. The restrictions caused by $cfg['Servers'][$i]['AllowNoPassword'] = false are bypassed     under certain PHP versions (e.g., version 5). This can allow the login of users who have no password set     even if the administrator has set $cfg['Servers'][$i]['AllowNoPassword'] to false (which is also the     default). This occurs because some implementations of the PHP substr function return false when given ''     as the first argument. (CVE-2017-18264)

  - phpMyAdmin 4.0, 4.4, and 4.6 are vulnerable to a DOS weakness in the table editing functionality     (CVE-2017-1000014)

  - phpMyAdmin 4.0, 4.4, and 4.6 are vulnerable to a CSS injection attack through crafted cookie parameters     (CVE-2017-1000015)

  - Cross-site scripting (XSS) vulnerability in db_central_columns.php in phpMyAdmin before 4.7.8 allows     remote authenticated users to inject arbitrary web script or HTML via a crafted URL. (CVE-2018-7260)

  - An issue was discovered in js/designer/move.js in phpMyAdmin before 4.8.2. A Cross-Site Scripting     vulnerability has been found where an attacker can use a crafted database name to trigger an XSS attack     when that database is referenced from the Designer feature. (CVE-2018-12581)

  - An attacker can exploit phpMyAdmin before 4.8.4 to leak the contents of a local file because of an error     in the transformation feature. The attacker must have access to the phpMyAdmin Configuration Storage     tables, although these can easily be created in any database to which the attacker has access. An attacker     must have valid credentials to log in to phpMyAdmin; this vulnerability does not allow an attacker to     circumvent the login system. (CVE-2018-19968)

  - In phpMyAdmin before 4.8.4, an XSS vulnerability was found in the navigation tree, where an attacker can     deliver a payload to a user through a crafted database/table name. (CVE-2018-19970)

  - An issue was discovered in phpMyAdmin before 4.8.5. A vulnerability was reported where a specially crafted     username can be used to trigger a SQL injection attack through the designer feature. (CVE-2019-6798)

  - An issue was discovered in phpMyAdmin before 4.9.0.1. A vulnerability was reported where a specially     crafted database name can be used to trigger an SQL injection attack through the designer feature.
    (CVE-2019-11768)

  - An issue was discovered in phpMyAdmin before 4.9.0. A vulnerability was found that allows an attacker to     trigger a CSRF attack against a phpMyAdmin user. The attacker can trick the user, for instance through a     broken <img> tag pointing at the victim's phpMyAdmin database, and the attacker can potentially deliver a     payload (such as a specific INSERT or DELETE statement) to the victim. (CVE-2019-12616)

  - A CSRF issue in phpMyAdmin 4.9.0.1 allows deletion of any server in the Setup page. (CVE-2019-12922)

  - phpMyAdmin before 4.9.2 does not escape certain Git information, related to     libraries/classes/Display/GitRevision.php and libraries/classes/Footer.php. (CVE-2019-19617)

  - In phpMyAdmin 4 before 4.9.4 and 5 before 5.0.1, SQL injection exists in the user accounts page. A     malicious user could inject custom SQL in place of their own username when creating queries to this page.
    An attacker must have a valid MySQL account to access the server. (CVE-2020-5504)

  - phpMyAdmin before 4.9.6 and 5.x before 5.0.3 allows XSS through the transformation feature via a crafted     link. (CVE-2020-26934)

  - An issue was discovered in SearchController in phpMyAdmin before 4.9.6 and 5.x before 5.0.3. A SQL     injection vulnerability was discovered in how phpMyAdmin processes SQL statements in the search feature.
    An attacker could use this flaw to inject malicious SQL in to a query. (CVE-2020-26935)

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The version of phpMyAdmin installed on the remote host does not correcty deal with malicious sql injected in place of a valid username when creating queries on the user accounts page leading to a SQL injection vulnerability. Note that the scanner has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Ubuntu 18.04 LTS host has a package installed that is affected by multiple vulnerabilities as referenced in the USN-4639-1 advisory.

  - Cross-site scripting (XSS) vulnerability in db_central_columns.php in phpMyAdmin before 4.7.8 allows     remote authenticated users to inject arbitrary web script or HTML via a crafted URL. (CVE-2018-7260)

  - An attacker can exploit phpMyAdmin before 4.8.4 to leak the contents of a local file because of an error     in the transformation feature. The attacker must have access to the phpMyAdmin Configuration Storage     tables, although these can easily be created in any database to which the attacker has access. An attacker     must have valid credentials to log in to phpMyAdmin; this vulnerability does not allow an attacker to     circumvent the login system. (CVE-2018-19968)

  - In phpMyAdmin before 4.8.4, an XSS vulnerability was found in the navigation tree, where an attacker can     deliver a payload to a user through a crafted database/table name. (CVE-2018-19970)

  - An issue was discovered in phpMyAdmin before 4.8.5. A vulnerability was reported where a specially crafted     username can be used to trigger a SQL injection attack through the designer feature. (CVE-2019-6798)

  - An issue was discovered in phpMyAdmin before 4.8.5. When the AllowArbitraryServer configuration setting is     set to true, with the use of a rogue MySQL server, an attacker can read any file on the server that the     web server's user can access. This is related to the mysql.allow_local_infile PHP configuration, and the     inadvertent ignoring of options(MYSQLI_OPT_LOCAL_INFILE calls. (CVE-2019-6799)

  - An issue was discovered in phpMyAdmin before 4.9.0.1. A vulnerability was reported where a specially     crafted database name can be used to trigger an SQL injection attack through the designer feature.
    (CVE-2019-11768)

  - An issue was discovered in phpMyAdmin before 4.9.0. A vulnerability was found that allows an attacker to     trigger a CSRF attack against a phpMyAdmin user. The attacker can trick the user, for instance through a     broken  tag pointing at the victim's phpMyAdmin database, and the attacker can potentially deliver a     payload (such as a specific INSERT or DELETE statement) to the victim. (CVE-2019-12616)

  - In phpMyAdmin 4 before 4.9.4 and 5 before 5.0.1, SQL injection exists in the user accounts page. A     malicious user could inject custom SQL in place of their own username when creating queries to this page.
    An attacker must have a valid MySQL account to access the server. (CVE-2020-5504)

  - In phpMyAdmin 4.x before 4.9.5 and 5.x before 5.0.2, a SQL injection vulnerability has been discovered     where certain parameters are not properly escaped when generating certain queries for search actions in     libraries/classes/Controllers/Table/TableSearchController.php. An attacker can generate a crafted database     or table name. The attack can be performed if a user attempts certain search operations on the malicious     database or table. (CVE-2020-10802)

  - In phpMyAdmin 4.x before 4.9.5 and 5.x before 5.0.2, a SQL injection vulnerability was discovered where     malicious code could be used to trigger an XSS attack through retrieving and displaying results (in     tbl_get_field.php and libraries/classes/Display/Results.php). The attacker must be able to insert crafted     data into certain database tables, which when retrieved (for instance, through the Browse tab) can trigger     the XSS attack. (CVE-2020-10803)

  - In phpMyAdmin 4.x before 4.9.5 and 5.x before 5.0.2, a SQL injection vulnerability was found in retrieval     of the current username (in libraries/classes/Server/Privileges.php and     libraries/classes/UserPassword.php). A malicious user with access to the server could create a crafted     username, and then trick the victim into performing specific actions with that user account (such as     editing its privileges). (CVE-2020-10804)

  - phpMyAdmin before 4.9.6 and 5.x before 5.0.3 allows XSS through the transformation feature via a crafted     link. (CVE-2020-26934)

  - An issue was discovered in SearchController in phpMyAdmin before 4.9.6 and 5.x before 5.0.3. A SQL     injection vulnerability was discovered in how phpMyAdmin processes SQL statements in the search feature.
    An attacker could use this flaw to inject malicious SQL in to a query. (CVE-2020-26935)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

According to its self-reported version number, the phpMyAdmin application hosted on the remote web server is 4.x prior to 4.9.4, or 5.x prior to 5.0.1. It is, therefore, affected by a SQL injection (SQLi) vulnerability in the user accounts page. An authenticated, remote attacker can exploit this, by injecting custom SQL in place of their own username, to inject or manipulate SQL queries in the back-end database, resulting in the disclosure or manipulation of arbitrary data.

Note that Nessus has not attempted to exploit these issues but has instead relied only on the application's self-reported version number.

In phpMyAdmin 4 before 4.9.4 and 5 before 5.0.1, SQL injection exists in the user accounts page. A malicious user could inject custom SQL in place of their own username when creating queries to this page. An attacker must have a valid MySQL account to access the server.

For Debian 8 'Jessie', this problem has been fixed in version 4:4.2.12-2+deb8u8.

We recommend that you upgrade your phpmyadmin packages.

NOTE: Tenable Network Security has extracted the preceding description block directly from the DLA security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

This update for phpMyAdmin to version 4.9.4 fixes the following issues :

  - CVE-2020-5504: SQL injection in user accounts page     (boo#1160456).

The phpMyAdmin development team reports :

A SQL injection flaw has been discovered in the user accounts page

ID	Name	Product	Family	Severity
183178	Ubuntu 16.04 ESM / 18.04 ESM / 20.04 ESM : phpMyAdmin vulnerabilities (USN-4843-1)	Nessus	Ubuntu Local Security Checks	critical
113300	phpMyAdmin 5.0.x < 5.0.1 SQL Injection	Web App Scanning	Component Vulnerability	high
113299	phpMyAdmin 4.8.x < 4.9.4 SQL Injection	Web App Scanning	Component Vulnerability	high
143119	Ubuntu 18.04 LTS : phpMyAdmin vulnerabilities (USN-4639-1)	Nessus	Ubuntu Local Security Checks	critical
138595	phpMyAdmin 4.x < 4.9.4 / 5.x < 5.0.1 SQLi (PMASA-2020-1)	Nessus	CGI abuses	high
132940	Debian DLA-2060-1 : phpmyadmin security update	Nessus	Debian Local Security Checks	high
132917	openSUSE Security Update : phpMyAdmin (openSUSE-2020-56)	Nessus	SuSE Local Security Checks	critical
132792	FreeBSD : phpMyAdmin -- SQL injection (16aed7b7-344a-11ea-9cdb-001b217b3468)	Nessus	FreeBSD Local Security Checks	high

Detections

Analytics

CVE-2020-5504

high

Tenable Plugins

critical

high

high

critical

high

high

critical

high