mysql database

  1. K

    What are MySQL triggers? And steps to use them

    MySQL triggers is an object which is attached with particular table and execute when that event occur. These triggers only work when any of these Mysql statements run like INSERT, UPDATE, DELETE etc. NOTE: You can only use triggers if you have MySQL SUPERUSER privileges. So you have your own...
  2. K

    After upgrade Mysql password not working

    We are getting error “Error establishing a database connection” after up gradation to MySQL 5.6.5 or newer version; the reason is new hashing method. Mysql older version used a hashing method to store password but newer version does not support hash method. You have to delete your current user...
  3. K

    Steps to take backup of single Mysql table

    You can follow below steps : You can create dump file : #mysqldump db_name table_name > table_name.sql You can create dump file from remote server: #mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql You can create dump file using phpmyadmin: Cpanel >>...
  4. K

    How can we rename mysql database in cpanel?

    You can follow below steps to rename mysql database: Login to cpanel. Search for “Mysql Databases” under Databases. Now select particular database which you want to rename from “Current Databases” list and click on “Rename” option. Enter your desired password and click on “Proceed” button. Now...
  5. K

    Steps to check Mysql database size via command

    Login to SSH via root. Now you have to enter below command: mysql -u username –p You will see password prompt you have to enter password of your database. You have to enter below command to display all the databases and also you can see its size in MB. You can use this command to check single...
  6. K

    How can we change Mysql root password via WHM?

    You can follow below steps to change Mysql root password: Login to WHM. Click on Mysql root password under “SQL services” tab. Now you have to enter new password of your Mysql database. You have to use STRONG and COMPLEX password for your database as everyone can access database. Do not use...
  7. K

    Steps to connect Mysql database via Mysql Workbench

    Mysql workbench is an Mysql client tool which helps to connect Mysql database. You can easily connect with mysql database from your computer with this mysql client. Here are the steps to use mysql client: Install mysql workbench and then open it. Click on “New Connection” and you will find...
  8. K

    How can we create Mysql database in DirectAdmin?

    You can follow below steps to create Mysql database. Login to DirectAdmin. Now click on “Mysql Management” link. Here you will find “Create New Database”, you have to click on it. Enter below details : Database Name Database Username Password of that user Re-type Password At last click on...
  9. K

    How can we increase database upload limit from phpmyadmin in cpanel?

    By default phpMyAdmin provide 50 MB mysql database but what if your database file size is more than 50MB. Let’s see how to increase mysql database upload limit in WHM. Login to WHM. Click on “Tweak settings” under "Service Configuration” tab. Now click on “PHP” tab to get options related to...
  10. bhawanisingh

    Steps to Drop all tables in MySQL database

    MySQL: MySQL is the popular open source database with relational database management system. It is used by web-based application and its performance is high, reliable and it is very easy to use. Table contains set of elements with rows and columns. Creating the table is same as creating a...
  11. bhawanisingh

    Steps to manage MySQL Database Backup

    Backup of Database is one of the most important things in Websites as if you don’t have proper backup and restore technique then all your data may get lost. The following text is to tell you about MySQL Databases’ Backup Creation and Restoration. In Linux, this task can be easily performed via...
  12. bhawanisingh

    How to take backup of MySql database through PhpMyAdmin ?

    If you are making any changes in your MySql database then you should first take backup of your database. We always recommend you to take backup of your MySql database before upgrade as you are working on your site from long time and don’t want to lose your data then it is the best option. You...
  13. bhawanisingh

    How do I Backup Mysql Database in CPanel ?

    If you have an online website which is built in content manager system like Joomla, wordpress, or any other cms then it is obvious that your website has Mysql database. To secure your database it is must to take back up of your database regularly. As you know every website has some back-end...
Top