Adding an user to a MySQL database with Cpanel goes as follows:
Login to Cpanel
Scroll down to: Site management Tools
And click the icon: MySQL Databases
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 an 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; at 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 an 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 setup 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.
Need more help ? try to watch this short video explaining you on how to setup a database, create a user and finally attach the user to the database. [Show Video]
