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 the Stackhero documentation!

Stackhero offers a ready-to-use MariaDB cloud solution that provides a host of benefits, including:

• Unlimited connections and transfers.
• phpMyAdmin web UI included.
• Effortless updates with just a click.
• Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's MariaDB cloud hosting solution!

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.