Changing the database user password using bash script? Change the database user password, need simple solution!! The MySQL community has depreciated “old_passwords” option since MySQL 5.6 version. So we won’t be able to recollect the password from an old password…
Tag: mysql
Managing comments on your WordPress site via PhpMyAdmin or SQL
Manage WordPress comments via MySQL commands. This is something interesting and time saving method. Yeah, it’s a bulk, one click option to remove unwanted comments from your WordPress websites. If you are using multiple WordPress websites, this should help you…
How to upgrade MySQL from 5.1 to 5.5 in Plesk server?
We all are familiar with the control panel Plesk. It’s one of the commonly using web hosting control panel in hosting industry. Plesk works on both Linux and Windows platform. In this blog post we discuss about the steps to…
Visual editor missing after WordPress auto update – version 4.7.2
Oh no!! It’s really frustrating! After the WordPress update visual editor is missing on my WordPress installation. What to do now? I woke up this morning with the WordPress auto update email and I ignored it like always do 🙂 Just…
Backup and restore MySQL database table via commandline
Managing databases via Linux shell is not a big deal. And we all are familiar with MySQL databases backup and restoration via CLI (Command Line Interface) using mysqldump and mysql commands. This is explained here >> Managing MySQL database backup…
How to monitor MySQL databases using mytop – CLI tool
In this article I’m explaining the usage of a smart command-line tool “mytop.” Which is similar in look to the basic resource monitoring tool “top.” By using this command, you can monitor the MySQL queries lively. There are a lot…
List all MySQL databases from Linux command line
Is it possible to get databases details from server command line? Yeah!! if there is a way to list and sort out the database details from server CLI (command line interface), it’ll speedup your troubleshooting procedure. We can use the…