Create a database and connect an application to it

Steps

1. Step 1: Create the database and user

   Open Account Manager › then MySQL Management → Create new Database. Name it demo, user demo, generate a password and save it. Note the full prefixed names DirectAdmin shows, such as acme_demo. How to create a MySQL database in DirectAdmin

2. Step 2: Open phpMyAdmin

   Open Extra Features › then phpMyAdmin and select your new database.

3. Step 3: Create a table

   Open the SQL tab and run:

   CREATE TABLE notes (
     id INT AUTO_INCREMENT PRIMARY KEY,
     body VARCHAR(255) NOT NULL
   );
   INSERT INTO notes (body) VALUES ('Hello from MySQL');

4. Step 4: Create a test script

   In System Info & Files › then File Manager, create public_html/dbtest-7h2k.php:

   <?php
   $pdo = new PDO('mysql:host=localhost;dbname=acme_demo;charset=utf8mb4',
       'acme_demo', 'YOUR_PASSWORD',
       [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
   foreach ($pdo->query('SELECT body FROM notes') as $row) {
       echo htmlspecialchars($row['body']);
   }

   Replace the names and password with yours.

5. Step 5: Visit it

   Open https://yourdomain.co.uk/dbtest-7h2k.php. You should see Hello from MySQL.

6. Step 6: Delete the test

   Delete the script (it contains a password), and drop the notes table or the whole test database when finished. Connecting a PHP application to your database