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…
Database
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…
Impossible to create database’s user::MySQL governor
At last I figured out the problem with MySQL DB user creation that I got!!! Here is the error details: When I tried to create a new database user through cPanel I got the following error! The adminbin “hooks” in…
How to change MySQL root password from Kloxo Panel
You can change MySQL root password from Kloxo panel by following the steps below: Step 1 : Login to Kloxo control panel, Click here for “How to access kloxo control panel” IP.ADDRESS:7778 Step 2 : Do the following steps: Admin…
MySQL Create DB, table and Insert contents from command line
We already discussed some basics of MySQL database management. Here is some more command line usages of MySQL with example. 1. To connect to MySQL we can use the command # mysql -u root -p Then, enter the MySQL root…
How to get the MySQL root password details – cPanel
The MySQL server saves its root password in a file “.my.cnf” under the root directory. You can find out its from the file as I mentioned. Example: root@server [~]# cat /root/.my.cnf [client] password=”)%:pV(Yo” user=root If you were loged in to…
How to create a New Database-user and Grand Permissions – MySQL
We already discussed about the creation of MySQL DB and DB users. Here I am explaining the commands which are using to Grand Privileges to users for accessing the Databases in your server. Enter the mysql prompt by following the…