mysql database

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...

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...

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 >>...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...