Tag: phpMyAdmin

MySQL Rejecting Correct Password “Error 1045: Access denied for user (using password: YES)”

If you’re certain the password is correct, it is most likely that MySQL is denying you access based on the specified host value for the user. In this article we will learn how to change a user’s host value in command line or phpMyAdmin.

Introduction This article is for users who are trying to log into MySQL with a correct password but are getting an error: “Error 1045: Access denied for user (using password: YES)” If you’ve forgotten your MySQL root password, please see this article: How to Reset the MySQL root password. If you are trying to log…

Continue reading MySQL Rejecting Correct Password “Error 1045: Access denied for user (using password: YES)”

Manually upgrade phpMyAdmin

How to Manually Upgrade phpMyAdmin

Since the release of Ubuntu 18.04 and other Linux distros, many people have been having compatibility issues with PHP 7.2 and phpMyAdmin 4.6 and above. In this article we will manually download and install the latest version of phpMyAdmin to resolve these issues.

Introduction This guide has been tested on Ubuntu 20.04, 18.04 and 16.04. It should also work for other Debian-based distributions without issue. For CentOS users, please refer to the comments section at the end of this page as commands will be different. I will try to update this guide for CentOS as soon as I…

Continue reading How to Manually Upgrade phpMyAdmin

phpMyAdmin and PHP 7 issues

Problem with phpMyAdmin and PHP 7.2: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”

It’s possible that when you installed phpMyAdmin, the version in the repository (phpMyAdmin v4.6.6) was not fully compatible with PHP 7.2. There is a newer version available on the official website (v4.9 as of writing), which fixes these compatibility issues with PHP 7.2.

sql.lib.php This error is caused by a line of code in /usr/share/phpmyadmin/libraries/sql.lib.php. If you don’t want to wait for the repositories to update with the latest version, it is strongly recommended that you manually upgrade to the latest version of phpMyAdmin yourself. Alternatively, you can make a change to sql.lib.php to temporarily fix the error. Firstly, backup sql.lib.php before editing.…

Continue reading Problem with phpMyAdmin and PHP 7.2: “Warning in ./libraries/sql.lib.php#613 count(): Parameter must be an array or an object that implements Countable”

Installing phpMyAdmin for Nginx on Ubuntu 18.04

Installing phpMyAdmin for Nginx on Ubuntu 18.04 / 19.10

In this guide we will install and configure phpMyAdmin to work with Nginx on Ubuntu Server 18.04 / 19.10. phpMyAdmin is open source free software, designed to handle the administration and management of MySQL databases through a graphic user interface.

Prerequisites You should be using a non-root user with sudo privileges as explained in Ubuntu 18.04 / 19.10 Initial Server Setup. You should also have your LEMP stack (Nginx, MySQL and PHP) already installed before continuing with this guide. If you don’t have these installed yet, please see Installing a LEMP Stack (Nginx, MySQL, PHP) on Ubuntu…

Continue reading Installing phpMyAdmin for Nginx on Ubuntu 18.04 / 19.10

Installing phpMyAdmin for Apache on Ubuntu 18.04

Installing phpMyAdmin for Apache on Ubuntu 18.04 / 19.10

In this guide we will install and configure phpMyAdmin to work with Apache on Ubuntu Server 18.04 / 19.10.

Video Tutorial

Prerequisites You should be using a non-root user with sudo privileges as explained in Ubuntu 18.04 Initial Server Setup. You should also have your LAMP stack already installed and serving web pages before continuing with this guide. Please see Installing a LAMP Stack (Apache, MySQL, PHP) on Ubuntu 18.04 / 19.10. 1. Install phpMyAdmin Let’s begin…

Continue reading Installing phpMyAdmin for Apache on Ubuntu 18.04 / 19.10

Access denied for user ‘root’@’localhost’

Can’t log into phpMyAdmin: mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’

MySQL 5.7 and above Since October 2015, root now requires sudo privileges in MySQL 5.7+ and phpMyAdmin will not be able to use root credentials. If you are trying to log into phpMyAdmin using an account other than root but you are getting an error “Access denied for user (using password: YES)”, please see this…

Continue reading Can’t log into phpMyAdmin: mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’

Guide: Installing phpMyAdmin for Apache on Ubuntu 16.04 / 17.10

In this guide we will install and configure phpMyAdmin to work with Apache on Ubuntu 16.04 / 17.10. Prerequisites You should be using a non-root user with sudo privileges as explained in Ubuntu 16.04 / 17.10 Initial Server Setup. You should also have your LAMP stack (Apache, MySQL and PHP) already installed before continuing with…

Continue reading Guide: Installing phpMyAdmin for Apache on Ubuntu 16.04 / 17.10

Guide: Installing phpMyAdmin for Nginx on Ubuntu 16.04 / 17.10

In this guide we will install and configure phpMyAdmin to work with Nginx on Ubuntu 16.04 / 17.10. Prerequisites You should be using a non-root user with sudo privileges as explained in Ubuntu 16.04 / 17.10 Initial Server Setup. You should also have your LEMP stack (Nginx, MySQL and PHP) already installed before continuing with…

Continue reading Guide: Installing phpMyAdmin for Nginx on Ubuntu 16.04 / 17.10