• FAQQuestions
  • Guides
When autocomplete results are available use up and down arrows to review and enter to go to the desired page. Touch device users, explore by touch or with swipe gestures.

Submit Support Ticket

Select the web hosting company you are a user of:

ACORN HOST

SITEWORKS

WTQ HOSTING

SKYSTRA

MERCHANTMOMS

ULTIMATE WEBHOSTING

Website

Create a new database user account

Contents

  1. Definitions
  2. Before you start
  3. Step by step

Definitions

A database user, also called a MySQL user, is an account with specific permissions to access and manage a database, helping securely control who can see or change your hosted website or app data.

Before you start

✅ When you install WordPress or any modern app, a database and default database user is automatically generated for you.

ℹ️ You can create a new database user manually for an existing database using the MySQL Databases tool.

⚠️ Usually, only advanced users or professional web developers should handle database tasks according to specific technical project requirements.

❌ Do not share your database user credential details publicly.

Step by step

1. Log in to your hosting control panel

2. Click on the MySQL Databases button

3. Click on Manage Users

4. Go to the Create User section

5. In the User Name field, type in a username suffix. You can name it however you like, by using a name, a word or letters, along with a series of digits. For example, we will name our user cloudhelper787 

6. For the Password field, click the dice ⚁ ⚁ button to generate a secure password

7. Click the Create button

8. In the User created section, you’ll see your full database user credentials. Highlight and copy down your username and password credentials on a secure note. After noting them, click the X at the top right.

9. You will now see your database user listed under the User Accounts section. Click its Manage button.

10. Go to Access to Databases and click the field under Grant access to additional database. Select the required database from the dropdown.

11. Click the + Grant Full Access button to assign the new database user to your database

12. By default, new database users will be granted all privileges (permission levels) to your database. If you want to modify the privileges for the user, click on the Privileges button.

13. You will get a dropdown of access levels. From here, you can check off or leave the permission levels you want for the database user. Once you are done, click the Save Changes button.

Related Posts

Transfer your website to us

Definitions When you transfer a website to us, ...

Fix the 'Error establishing a database connection' error

Definitions The 'Error establishing a database ...

Create a new database

Definitions A database stores and organizes the...

Manage your databases with phpMyAdmin

Definitions phpMyAdmin is a tool that lets you ...

Restore your data from backups

Definitions Data restores from backups roll bac...

Post navigation

Previous
Next

Search and find answers to most common web hosting and email service questions.

Dashboard Login
  • Skystra
  • MerchantMoms
  • Ultimate Web Hosting UK
Dashboard Login
  • SiteWorks
  • WTQ Hosting
  • Tiffin Web Services

© Cloud Help Center 2024