How do I assign a user to a database in cPanel?

By Spiderz • November 21, 2023

After creating a database and a user, you can assign the user to the database in cPanel:

  1. Go to the ‘Databases’ section in cPanel and select ‘MySQL Databases.’
  2. Scroll to the ‘Add User to Database’ section, select the user and the database from the respective drop-down menus.
  3. Click ‘Add’ and then select the appropriate privileges for the user on the database.
  4. Finally, click ‘Make Changes’ to complete the assignment.

Good to Know: Assigning specific privileges to users helps maintain database security by ensuring users can only perform tasks necessary for their role.

Founded in Dubai in 2002, Spiderz is an enterprising, family-run web and software services company. We work with businesses across the UAE to design, build, and support a wide range of applications and systems in AI, cloud, e-commerce, and web technologies, along with digital media and branding.

Back to the Blog