A MySQL user is an account that has specific permissions to access and interact with a database. Creating one can help with securely managing who can see or change your website or web app stored data.
You can create a MySQL user from your hosting control panel.
1. Log in to your hosting control panel
2. Click on the MySQL Databases button
3. Locate the database you want to create a MySQL user for and click directly on its name
4. At the top, click the Create New User button
5. In the popup, type in a database username. In the password field, generate a new password and/or input your own. If generating one, click the dice ⚁ ⚁ on the left hand side and the system will generate one for you. Then, click on the eye icon to the right 👁️ to reveal it. Note down the database user credentials. Once you’re done, click the Create button.
6. You will get a popup confirmation message once your MySQL user has been created. The popup will display your MySQL user credentials again, if you haven’t done so already, note these details down in a secure spot. Once noted, you can click the Close button.
7. You will now see your MySQL user listed. By default, MySQL users will be granted all privileges (permission levels), if you want to modify the privileges the specific user for your database, click on Modify Privileges next to the MySQL user.
8. You will get a Change Privileges popup screen. From here, you can check or leave checked the permission levels you want for the MySQL user. Once you are done, click Save.