Managing MySQL Databases and Users in cPanel
To change a MySQL user's password, access ''MySQL 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 create a MySQL database, go to cPanel, click on MySQL Databases, enter a database name, then click Create Database. Your new database is now ready for use. Check the Current Databases table for confirmation. Next, add a MySQL user for database management.
To modify a database user's privileges, go to MySQL 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 MySQL user to a database, go to MySQL 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 ''MySQL 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 MySQL Databases in cPanel, select the database, and click Check Database. To repair, select Repair Database and the system will automatically fix any issues detected.
Our website uses cookies for essential functions, analytics, and advertising. By clicking 'Accept', you consent to our cookie policy and data use.