Install Mongdb 3.8 Ubuntu 14.4,16.04,18.04 LTS MongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need sudo apt-key adv –keyserver hkp://keyserver.ubuntu.com:80 –recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 sudo apt-get install gnupg echo “deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.6 multiverse” | sudo tee /etc/apt/sources.list.Continue Reading

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 singleContinue Reading

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

#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured) 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 asContinue Reading

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::/7Continue Reading

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;

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 itContinue Reading

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_expr’]) == 1) Save the file and come toContinue Reading

phpmyadmin not work showing script sudo apt update sudo apt upgrade sudo apt-get install libapache2-mod-php sudo apt-get install yourphpversion-mbstring sudo apt-get install yourphpversion-mysqli