MySQL

How to Install SQL Server Management Studio on a Windows server

In this article, we will explain to you how to install SQL Server Management Studio on a Windows Server. Let us install SQL Server Management Studio: 1. You can use the below link to download the SSMS file: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 2) Once it is downloaded, double-click on the “SSMS-Setup-ENU” file. 3) It will be directed to …

How to Install SQL Server Management Studio on a Windows server Read More »

How to Grant all Privileges to the User in cPanel

This article describes how to grant a user all privileges in MySQL. The MySQL privilege system allows a user to make particular modifications to a database after they have been verified. A user can perform database actions such as INSERT, SELECT, DELETE and UPDATE, based on the abilities allowed in cPanel. To give a user …

How to Grant all Privileges to the User in cPanel Read More »

Why & How to Optimise & Repair MySQL Database using phpMyAdmin in cPanel

This tutorial will explain how to optimize and repair MySQL Database using phpMyAdmin in cPanel. Why Optimise and Repair MySQL Database? Before moving further on the process of optimizing and repairing the MySQL database let us understand why it is necessary to do so: 1. Databases develop to a considerable extent when a website receives …

Why & How to Optimise & Repair MySQL Database using phpMyAdmin in cPanel Read More »

How to change MySQL database user’s password from cPanel

The process of changing MySQL database user password from cPanel is described in this article. Let’s follow the steps to change the MySQL database user password from cPanel: 1. Enter in your cPanel account. 2. You will enter into the cPanel homepage. Select the “Database” section and click on the “MySQL Databases” icon from it. …

How to change MySQL database user’s password from cPanel Read More »

How to Upgrade MySQL on the cPanel (Installation Guide)

In the web hosting industry cPanel control panel is the only control panel which supports easy-to-understand GUI-based (Graphical User Interface) to manage the hosting resources of a website. cPanel hosting supports different features to manage hosting resources which include Spam Assassin,  Email forwarding, Awstats, and MySQL to support and manage databases of a website. And …

How to Upgrade MySQL on the cPanel (Installation Guide) Read More »

How to Backup and Restore Magento Database on Dedicated Server

Magento is an Open Source eCommerce Platform that helps in your online business and store growth. Backup of Magento eCommerce software database and website is one of the vital steps, webmasters should always perform. Usually, backing up the website data is planning to prevent data from worst scenarios. If a disaster takes place, you will …

How to Backup and Restore Magento Database on Dedicated Server Read More »

How to export/import MySQL database with correct character set on a Dedicated server

To Export/Import MySQL database with the correct character set on a dedicated server exporting your database with the correct character set is important to avoid any kind of problems with data that has non-English characters within the table. For example, if the character set of your data is Unicode (UTF8) you can use the following command …

How to export/import MySQL database with correct character set on a Dedicated server Read More »