#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…

Setup nginx with apache in ubuntu

Read PHP file Apache & Nginx 1) add the following code in the file “sudo nano /etc/nginx/sites-enabled/default” location ~ \.php$ { include snippets/fastcgi-php.conf; fastcgi_pass unix:/run/php/php7.1-fpm.sock; } location ~ /\.ht { deny all; } 2) And also change the port as per your need server { listen 8080 default_server; listen [::]:8080 default_server; } 3) Setup PHPMyAdRead 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…

500 Internal Server Error & file permission

// all Directories: go to file location Ex. cd  /var/www/project folder path (then run this command) find . -type d -exec chmod 755 {} \; //All Files: find . -type f -exec chmod 644 {} \; And Enable Mod_rewrite mode How to enable mod_rewrite for Apache 2.2 order to use mod_rewrite you can type the following command in the terminal: sudo a2enmod rewrite Read More…