WHM provides a very friendly interface for managing sites, users and databases on the server. Sometimes you have to create several hundreds of accounts for different clients (for example, migrating from a regular server to WHM). In this case you can spend weeks on mouse clicks in the web interface.
In this case it is much easier to create accounts using prepared WHM shell scripts. In this particular case
wwwacct will help us.
To create an account
account with password
password for the site
websitename.com, use the following command:
/scripts/wwwacct **websitename.com** **account** **password**
Create database in
create database account_dbname; grant all privileges on **account_dbname**.* to **account_dbuser**@localhost identified by '**password**';
Link the mysql database and the user with the newly created account:
/usr/local/cpanel/bin/dbmaptool **account** -type mysql -dbs '**account_dbname**' /usr/local/cpanel/bin/dbmaptool **account** -type mysql -dbusers '**account_dbuser**'