Short answer
In DirectAdmin open Account Manager then MySQL Management and create the database along with a user, then note the database name, username and password. Your application needs all three plus the host, which is
localhost.DirectAdmin prefixes the name with your account username, so a database you call blog becomes something like user_blog. Use the full prefixed name in your configuration file.
Learn more
- How to create a MySQL database in DirectAdminCreate a MySQL/MariaDB database and user in DirectAdmin, understand the account prefix, and note the details your application needs.
- Connecting a PHP application to your databaseThe connection details for Traxio databases and working examples with PDO and mysqli, including safe queries and keeping credentials private.
- Managing database users and privilegesAdd users to a database, choose privileges, use separate users per application, and remove access you no longer need.
Step-by-step
- Create a database and connect an application to itBeginner · 15 min · 6 steps
Every Traxio account includes a MySQL database with phpMyAdmin. If you’re still choosing a host, PHP and MySQL hosting is free for 30 days, then £0.99 a month.