MariaDB: Creating a user on MariaDB using phpMyAdmin

This documentation is part of the Getting started guide. View the full guide here: How to get started with MariaDB.

👋 Welcome to Stackhero documentation

Stackhero provides a ready-to-use MariaDB cloud service designed for production workloads. You get:

• Unlimited connections and data transfers.
• Built-in phpMyAdmin web interface for database management.
• One-click updates for easy maintenance.
• High performance and strong security on private, dedicated infrastructure.

Launch a fully managed MariaDB instance in minutes. Stackhero handles setup, updates, and security so you can focus on your application. Learn more about MariaDB cloud hosting.

For better security, it is best to create a dedicated user for your application instead of using the "root" user. You can easily do this in phpMyAdmin:

1. In phpMyAdmin, click on User accounts at the top.
2. Click on Add user account.
3. Fill out the form:
   • Choose a username (often your application name).
   • Click Generate password for a strong password, and copy it.
   • Check Create database with same name and grant all privileges.

Once submitted, your new user and a matching database will be created.