Knowledge Base

Creating and Managing Databases

MySQL databases are required for WordPress and many other web applications.

Creating a New Database

1. Log into DirectAdmin
2. Click MySQL Management
3. Click Create new Database
4. Enter a database name (will be prefixed with your username)
5. Enter a username for the database
6. Enter a strong password (or click generate)
7. Click Create

Important: Save Your Credentials

Write down the following information - you'll need it to connect your application:

• Database Name: username_dbname
• Database User: username_dbuser
• Password: (the one you created)
• Host: localhost

Accessing phpMyAdmin

To manage your database visually:

1. Go to MySQL Management
2. Click phpMyAdmin next to your database

Importing a Database

1. Open phpMyAdmin
2. Select your database from the left sidebar
3. Click the Import tab
4. Choose your SQL file
5. Click Go

Deleting a Database

1. Go to MySQL Management
2. Click the trash icon next to the database
3. Confirm deletion

Warning: This permanently deletes all data!