Can I create a database via SSH/Terminal?

[Jordz2203]

Hi,
Im making a cli script to setup clients websites, but the issue I am having is database creation, how can I create a DB via the CLI for the user I am logged in as?

 

[Zhenyapan]

you can do it as root, connect to mysql/mariadb with da_admin credentials from /usr/local/directadmin/conf/my.cnf

 

[Jordz2203]

you can do it as root, connect to mysql/mariadb with da_admin credentials from /usr/local/directadmin/conf/my.cnf

Can I do it as a user? I have an external system connecting to the user account and running CLI commands

 

[zEitEr]

Use DirectAdmin API for it. A MySQL DB can be created via API with user's credentials, no admin's password is required.