Managing MariaDB Databases and Users in cPanel

To change a MariaDB user's password, access ''Manage My Databases'' in cPanel. Locate the user, click ''Change Password'', enter new password in the boxes, and then click ''Change Password''. The new password takes immediate effect.

To modify a database user's privileges, go to MariaDB Databases in cPanel. Locate the user under Current Databases, click on the username to access Manage User Privileges. Select or unselect privileges, then click Make Changes.

To add a MariaDB user to a database, go to Manage My Databases in cPanel. Choose the user and database, grant privileges, then click Add and Make Changes. The user will now be listed in the Current Databases table.

To create a new MySQL user in cPanel, go to ''Manage My Databases'', enter username and password, then click ''Create User''. The new user will appear in the 'Current Users' table.

To check a database for errors, go to Manage My Databases in cPanel, select the database, and click Check Database. To repair, select Repair Database and the system will automatically fix any issues detected.

To delete a MariaDB database, go to cPanel, select Manage My Databases, find the database, and click Delete Database. Confirm the deletion on the next screen by clicking Delete Database.