databases

How to Add a User to a Database and Grant Privileges

Log in to your cPanel account. In the Databases section, click on MySQL Databases. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database from the list. Click on Add. On Manage User Privileges. Mark the box ALL PRIVILEGES and click on Make Changes.


August 28, 2023

How to Create a Database Username in cPanel

Log in to your cPanel account. In the Databases section, click on MySQL Databases. Under MySQL Users, in the Username field, enter the new username you want to create. Enter your new password or use a password generator. Click on Create a User. Tip: Write down the database username and password on a notepad so you can easily recall them while installing a script manually.


August 28, 2023

How to Rename a Database in cPanel

Log in to your cPanel account. In the Databases section, click on MySQL Databases. Under Current Databases, you can see a list of all your databases. Locate the Database and then click on Rename. Change the database name and click on Proceed.


August 28, 2023

How to Repair a Database via phpMyAdmin in cPanel

Log in to your cPanel account. In the Databases section, click on phpMyAdmin. Click the Expand icon from the navigation tree in the left sidebar. Scroll down and mark Check All. Then click on the drop-down arrow and select Repair table. If the table has been repaired successfully, it will show an OK message. Otherwise, it will display an error on some tables.


August 28, 2023

How to Create a Database in cPanel

Log in to your cPanel account. In the Databases section, click on MySQL Databases. In the New Database field, enter a name for the new database you wish to create. Click on Create Database.


August 28, 2023