Users with privileges get the potential to adjust and manage databases. You can control user database privileges as well as add, modify, and delete databases and customers. Let’s have a look at how to update database User Privileges in Plesk: 1. Log in to Plesk. 2. From the navigation menu, choose Databases. 3. Go to […]
Articles Tagged: database
How To Edit A WordPress Database?
Following are the guidelines I would like to share with website hosting clients who are going to host their blog or website based on WordPress. Find out the following in the downloaded and unzipped WordPress program on your computer and edit it as I am placing the instruction under each of it. // ** MySQL settings […]
What Is Index In MySQL Database?
Let the web hosting account be of any type either Windows Web Hosting or Linux Web Hosting, MySQL supports both types of web hosting services and is very popular as a database. The websites which have large data in their MySQL databases are supposed to optimize it which enables them for enhanced collation of data and indexing. […]
Steps To Change The Database Engine Of A MySQL Database Table.
Here is the process of changing the database engine of the MySQL table. Suppose the table name is my_table which resided in your database and it uses MyEng engine which you want to change as my DB. Login into your website hosting account Open your phpMyAdmin tools and click on the database which contains my_table (the […]
How To Back Up And Restore MySQL Database Using PHPMyAdmin
phpMyAdmin is widely used by a large number of web hosting clients because it is one of the most reliable ways to backup and restores MySQL databases. There are the following simple steps to backup and restore your MySQL database from your hosting account. Backup Process Go to phpMyAdmin Click on the database name which is […]
What are the Numbers of Maximum Connections Allowed for a Particular Database?
Allocating the resources in a proper manner and being assigned for optimum use is the main intention of any hosting company. Similarly, all of our shared hosting and reseller hosting packages allow up to 30 simultaneous connections per database user. As per this, a user is free to use his allocated space and connection for […]