This guide explains how to add a user to a MySQL database. The most extensively used open-source relational database, MySQL is used as the main relational data storage for numerous well-known websites, programmes, and commercial goods. Let us follow the steps: Log in to your cPanel account. Select the “Databases” category, then click on the …
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 »
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 »
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 »
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 »
Introduction The root MySQL user’s password needs to be changed if an error takes place in the WHM or cPanel as shown below. In this KB, we have outlined simple steps to change the password. The error you might encounter in cPanel & WHM is: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: …
How to change the password of the MySQL root user Read More »
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 »
On many occasions, you might have noticed that users are running an unwanted or malicious applications on servers that they should not run at all. To stop users from running such apps which are against your service policy you can configure WHM to kill background processes that are initiated by users on the dedicated servers. …
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 »
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 »