> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dangoweb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MySQL

> Learn how to set up and use your MySQL database.

<Info>phpMyAdmin is built in to [<Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/directadmin.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=c0de1870528a3e8f5ac7adc3d416a84a" width="100" height="100" data-path="icons/directadmin/directadmin.svg" /> DirectAdmin](/web-hosting/directadmin) as an web alternative to MySQL.</Info>

## Log In to DirectAdmin

[Log in](/help/web-hosting/directadmin/logging-in) to the [<Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/directadmin.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=c0de1870528a3e8f5ac7adc3d416a84a" width="100" height="100" data-path="icons/directadmin/directadmin.svg" /> DirectAdmin](/web-hosting/directadmin) control panel and navigate to the <Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/databases.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=801944cee045f7e7ec21ce888cebcfc6" width="50" height="50" data-path="icons/directadmin/databases.svg" /> **Databases** tab.

## Create Database

On the bottom of the page, fill out a database name and click "Create". If you would like to set your own default username and password for the database, click "Advanced mode" and fill that out before creating. Once your database is created, a popup will appear listing your connection details. You can use any SQL management application to browse or edit your database.

<Frame caption="Create Database">
  <img src="https://mintcdn.com/dangowebsolutions/D9EO2DwLBeZJ4JPL/directadmin-create-database.png?fit=max&auto=format&n=D9EO2DwLBeZJ4JPL&q=85&s=322737f3542b3eb3e73a33f793593ce4" alt="Create Database" width="1896" height="319" data-path="directadmin-create-database.png" />
</Frame>

## Connect to Database

Locate your favorite SQL Database manager program, whether online or downloaded - either can be used. You can connect using the below:

Type: MySQL\
Host: `da.dangoweb.com`\
Port: `3306`\
Username: Database Account Username\
Password: Database Account Password

<Frame caption="Connect to Database">
  <img src="https://mintcdn.com/dangowebsolutions/1OoprS6K7ywKu0_w/database-connect.png?fit=max&auto=format&n=1OoprS6K7ywKu0_w&q=85&s=25fa1c4922b110a6db5962b522bd623d" alt="Connect to Database" width="580" height="516" data-path="database-connect.png" />
</Frame>

### phpMyAdmin

If you do not have a downloaded SQL client, you may use the built-in phpMyAdmin panel to manage and edit your database.

Once you are in <Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/directadmin.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=c0de1870528a3e8f5ac7adc3d416a84a" width="100" height="100" data-path="icons/directadmin/directadmin.svg" /> **DirectAdmin**, locate and open the <Icon icon="https://mintcdn.com/dangowebsolutions/j-uP3DKiLJ2Amixo/icons/directadmin/phpmyadmin.svg?fit=max&auto=format&n=j-uP3DKiLJ2Amixo&q=85&s=2b20374840bb93fa99421778301e7c55" width="50" height="50" data-path="icons/directadmin/phpmyadmin.svg" /> **phpMyAdmin** tab under **Extra Features**. You can see all your databases on the left side, and you can select one to view it's tables and begin constructing your database.

<Frame caption="phpMyAdmin">
  <img src="https://mintcdn.com/dangowebsolutions/1NBVQ-ho_RBVueH4/mysql-phpmyadmin.png?fit=max&auto=format&n=1NBVQ-ho_RBVueH4&q=85&s=516439547a185e670c4b7df89a1e3be3" alt="phpMyAdmin" width="1290" height="692" data-path="mysql-phpmyadmin.png" />
</Frame>

## Modify Database

Although you cannot change your database name once created, you can add users, import, export, repair, and optimize your database from <Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/directadmin.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=c0de1870528a3e8f5ac7adc3d416a84a" width="100" height="100" data-path="icons/directadmin/directadmin.svg" /> **DirectAdmin**. To do so, go to the <Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/databases.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=801944cee045f7e7ec21ce888cebcfc6" width="50" height="50" data-path="icons/directadmin/databases.svg" /> **Databases** tab and click on the database you would like to modify. At the bottom of the page you should see all modification options.

<Frame caption="Modify Database">
  <img src="https://mintcdn.com/dangowebsolutions/D9EO2DwLBeZJ4JPL/directadmin-modify-database.png?fit=max&auto=format&n=D9EO2DwLBeZJ4JPL&q=85&s=59f928a5c58b3d219e8ddbf1dc422477" alt="Modify Database" width="1896" height="882" data-path="directadmin-modify-database.png" />
</Frame>

### Manage Users

On the same page you should see a section named "User Access". Through there you can add users, delete users, and change user privileges. These are different user accounts that can be used to log into the database and make edits. You should see your default account already there.

## Delete Database

If you ever need to delete a database, go to the <Icon icon="https://mintcdn.com/dangowebsolutions/h7v7ncdoSDUTq6Mf/icons/directadmin/databases.svg?fit=max&auto=format&n=h7v7ncdoSDUTq6Mf&q=85&s=801944cee045f7e7ec21ce888cebcfc6" width="50" height="50" data-path="icons/directadmin/databases.svg" /> **Databases** tab and click the "Delete" button next to the database you would like to delete.

<Frame caption="Delete Database">
  <img src="https://mintcdn.com/dangowebsolutions/D9EO2DwLBeZJ4JPL/directadmin-delete-database.png?fit=max&auto=format&n=D9EO2DwLBeZJ4JPL&q=85&s=e0f8af23c23a03d288a1778dab61697c" alt="Delete Database" width="249" height="113" data-path="directadmin-delete-database.png" />
</Frame>
