You can create databases and users for your Web site using Webmin, phpMyAdmin, or cPanel and other options. Is there a best way? Is there an easiest way? phpMyAdmin kills the rest for easy creation.
Webmin makes you create a database then create a user then create a connection between the two. There are endless options you may never use and some options are repeated in several places without telling you how they apply. I attempted to use Webmin for a simple setup and the result did not work.
cPanel hast a database creation page that works. You then go into a database user page that works. You then connect your user to the database and that works. cPanel shows only the options you need. None of the options are repeated. For a typical Web application the first user is also the database administrator and you select all privileges when connecting the user to the database. After your database and user are created, cPanel uses phpMyAdmin for everything else.
phpMyAdmin has the easiest approach. Select
Add a new user. Enter the usual user name and password. Select local host. Now here is the magic. Scroll down to Database for user. Select
Create database with same name and grant all privileges. Select
Go. Done. The user and database created in one hit.