---
title: "Create & Manage MySQL Databases | FPS.ms"
description: "Create MySQL databases on your FPS.ms web hosting. Set up database users, find connection details, and manage your data."
url: https://fps.ms/docs/webhosting/managing-databases
---
# Managing Databases

Your FPS.ms web hosting service includes MySQL databases for your websites and applications. You can create, manage, and delete databases from the panel.

## Creating a new database

1. Go to the **Databases** section of your web hosting server
2. Click **Create Database**
3. Fill in the following fields:
    - **Database name** -- alphanumeric characters only (your username is automatically prefixed)
    - **Database user** -- the username to connect with
    - **Database password** -- minimum 8 characters
4. Click **Create**

Your database will be named `yourusername_dbname` and the user will be `yourusername_dbuser`.

## Connection details

Use these details to connect your website or application to the database:

- **Host:** `localhost` (when connecting from your web hosting server)
- **Port:** `3306`
- **Database:** `yourusername_dbname`
- **Username:** `yourusername_dbuser`
- **Password:** the password you set during creation

!!! tip "PHP Connection"
    In your PHP code, you can connect using:
    ```php
    $conn = new mysqli('localhost', 'yourusername_dbuser', 'your_password', 'yourusername_dbname');
    ```

## Accessing phpMyAdmin

If phpMyAdmin is available on your hosting server, you can access it from the **Databases** section to visually browse and manage your database tables, run SQL queries, and import or export data.

## Deleting a database

1. Go to the **Databases** section
2. Find the database you want to remove
3. Click **Delete** and confirm

!!! danger "Permanent Action"
    Deleting a database permanently removes all data. Make sure to create a backup before deleting a database you may still need.

---

[FPS.ms](https://fps.ms/index.html.md) · [All pages](https://fps.ms/llms.txt) · [Documentation](https://fps.ms/docs/llms.txt)