#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)

#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured) Connection for control users as defined in your configuration failed. Solution :- It turns out that the solution is to stop all the services and solve the “Another daemon is already running” issue. The commands i used to solve the issue are as follows: su passwd ******* Read More…

Access to the requested object is only available from the local network phpmyadmin

Access to the requested object is only available from the local network phpmyadmin sudo /opt/lampp/etc/extra/httpd-xampp.conf Comment “Deny from all” in the following section,      Change file     # # New XAMPP security concept # <LocationMatch “^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-status|server-info))”> Order deny,allow #Deny from all #RequiRead More…

Uninstall or Completely remove mysql from Ubuntu

Uninstall or Completely remove mysql from ubuntu 16-04 While upgrading from ubuntu 16.04.1 to ubuntu 16.04.03, we had face once issue that we unexpected.This incident are cause by mysql server update, while setting up the mysql by apt, its hang on the server and will not work for leaving it around one hours.So we decide to remove the mysql server and reinstall again, below are the step that we weRead More…

Warning in ./libraries/sql.lib.php#601 count(): Parameter must be an array or an object that implements Countable

Manual Method: Open sql.lib.php file nano /usr/share/phpmyadmin/libraries/sql.lib.php Find for count($analyzed_sql_results[‘select_expr’] code on file. You can get this at line ~613. You can see this below wrong code || (count($analyzed_sql_results[‘select_expr’] == 1) Just replace that wrong code with this below one || ((count($analyzed_sql_results[‘select_exRead More…

Warning in ._libraries_plugin_interface.lib.php#551

Warning in ._libraries_plugin_interface.lib.php#551 sudo gedit /usr/share/phpmyadmin/libraries/plugin_interface.lib.php search with “$options != null” and find the following codes: if ($options != null && count($options) > 0) { Replace the above line with the following line: if ($options != null && count((array)$options) > 0) {  sudoRead More…