sudo nano /etc/apache2/sites-available/default <VirtualHost *:80>         ServerAdmin webmaster@localhost         DocumentRoot /var/www         <Directory />                 Options FollowSymLinks                 AllowOverride None         </Directory>    Read More →

Export all databases via terminal 🙂 ssh root@address user password ******** cd Saving path mysqldump -u root -p –all-databases > all_dbs.sql databases Password *********** Export single databases via terminal 🙂 ssh root@address user password ******** cd Saving path mysqldump -u root -p databases_name > databases_name.sql databases Password *********** IMPOrt singleRead More →

MySQL import got a packet bigger than max_allowed_packet bytes #1153 – Got a packet bigger than ‘max_allowed_packet bytes Step 1:- Open this file my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_allowed_packet = 128M (Add this line) Restart mysql sudo /etc/init.d/mysqld restart

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 #Require local Allow from ::1 127.0.0.0/8 \ fc00::/7Read More →

Delete a Database in MySQL on command’s  mysql -u root -p mysql> DROP DATABASE name_database; Or mysqladmin -u[username] -p[password] drop [database] DROP DATABASE ‘name-database’; EXIT;

Press Alt+Ctrl+t  Go to download path the run this command. Download the app Click here sudo apt update sudo apt upgrade sudo dpkg -i file location with extension face Any error like Errors were encountered while processing: Skype Solution sudo apt-get -f install sudo apt update sudo apt upgrade thenRead More →

tgo To switch to PHP 4.4: AddHandler application/x-httpd-php4 .php To switch to PHP 5.0: AddHandler application/x-httpd-php5 .php To switch to PHP 5.1: AddHandler application/x-httpd-php51 .php To switch to PHP 5.2: AddHandler application/x-httpd-php52 .php To switch to PHP 5.3: AddHandler application/x-httpd-php53 .php To switch to PHP 5.4: AddHandler application/x-httpd-php54 .php ToRead More →

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 itRead More →

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 [::]:8080Read More →