Open Ticket
Try it on your own server
KVM VPS hosting
From $10.00 USD a month NVMe SSD and full root access, with Free Basic Managed Support.
See plans
Stuck on a step?
Hire a cPanel admin
Hardening, migrations and 24/7 monitoring by our cPanel engineers, with no long-term contract.
See how it works
You will see each database with the options to Delete, check or Repair.
If a database does not have its own users yet they will appear without the
'users in' topic.
Scroll down to "Existing MySQL Users" at the bottom you can add a user.
The username you enter will be prefixed with cpanelusername_
So if you create a username for a database called 'mydatabase' it will be named automatically cpanelusername_mydatabase
After creating a username you can ADD the user to your database;
Scroll a bit back to; Grant permissions on a MySQL database to a MySQL user
At the field User: select the user created; in the field MySQL Database you select the database you want this user to be part of.
Next is choosing privileges for this user. If you just need a user to handle the whole database you should just select the 'ALL' privileges. Only if you know what you are doing you could select any of the others. Click Grant permissions to activate the user on the selected database.
The Database permissions have been set up now, now you can let the program know which userid and password it should use to access your database. As this is different with any application these instructions can't be described.
Related services
KVM VPS hosting
NVMe SSD and full root access, with Free Basic Managed Support.
Unmanaged dedicated servers
full root access and free IPMI KVM, with Free Basic Managed Support.
Managed dedicated servers
our engineers look after the server for you, from $135 a month.
