Warning in ./libraries/sql.lib.php#601 count(): Parameter must be an array or an object that implements Countable || (count($analyzed_sql_results[‘select_expr’] == 1) that’s missing close bracket ‘)’ before operation with 1. So changed it to || (count($analyzed_sql_results[‘select_expr’]) == 1 remove last close bracket ‘)’ at this line like this, ...
Read More
Edit file /usr/share/phpmyadmin/libraries/sql.lib.php using this command: sudo nano +613 /usr/share/phpmyadmin/libraries/sql.lib.php On line 613 the count function always evaluates to true since there is no closing parenthesis after $analyzed_sql_results['select_expr']. Making the below replacements resolves this, then you will need to delete the last closing parenthesis on line 614, as it's now an extra parenthesis. Replace: ((empty($analyzed_sql_results['select_expr'])) || (count($analyzed_sql_results['select_expr'] == 1) ...
Read More
MySQL 5.7 and above Creating a Superuser for phpMyAdmin In terminal, log in to MySQL as root. sudo mysql -p -u root CREATE USER 'pmauser'@'localhost' IDENTIFIED BY 'password_here'; Now we will grant superuser privilege to our new user pmauser. GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'localhost' WITH GRANT OPTION; You should now be able to access phpMyAdmin using this new user account....
Read More
sudo apt-get remove --purge phpmyadmin php-gettext php-mbstring -y sudo apt-get autoremove -y sudo apt-get update sudo apt-get install phpmyadmin php-gettext php-mbstring -y...
Read More