RSSAll Entries Tagged With: "MySQL Database"

How to Repair a MySQL Database

How to Repair a MySQL Database

Database is the heart of any website, blog, etc. It should be handled with delicate care. To repair a MySQL Database, follow the instructions below: Procedure: 1. On the homepage of your cPanel, click the MySQL Databases icon under Databases. 2. Under the Modify Databases, select the database you want to check from the drop […]

How to Check a MySQL Database

How to Check a MySQL Database

To check a MySQL Database, follow the instructions below: Procedure: 1. On the homepage of your cPanel, click the MySQL Databases icon under Databases. 2. Under the Modify Databases, select the database you want to check from the drop down menu. 3. When you are done, click the Check DB button. 4. cPanel will run […]

How to Add a User to the MySQL Database

How to Add a User to the MySQL Database

Administrators can define which users have priviledge with the databse. For example, the user will be able to add or delete the database. To add a user to the MySQL database, follow the instructions below. Procedure: 1. On the homepage of your cPanel, click the MySQL Databases icon under Databases. 2. Under Add User to […]

How to Create a User for a MySQL Database

How to Create a User for a MySQL Database

If you want to create a new user for a MySQL database, follow the instructions below: Procedure: 1. On the homepage of your cPanel, click the MySQL Databases icon under Databases. 2. Under the MySQL Users, enter a username in the Username field. 3. Enter a password in the Password field. 4. Reenter the password […]

How to Backup a MySQL Database with PhpMyAdmin

How to Backup a MySQL Database with PhpMyAdmin

Backing up your database is important to prevent losing your files when a server failure happens. A website that operates with a database often have a higher risk that a static website. Therefore, you need to be prepared for the day when your SQL database crashes. When you are upgrading your WordPress version, you should […]