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

#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured) Connection for control user 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.Read More →

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 \ 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;

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 →

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

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