MySQL: Creating a user on MySQL using phpMyAdmin

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

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use MySQL 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 MySQL cloud hosting solution!

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

1. In phpMyAdmin, select User accounts from the top menu.

2. Click Add user account.

3. Fill out the user creation form:

   • Enter an account name (usually your application's name)
   • Click Generate password for a secure password and copy it to your clipboard
   • Select Create database with same name and grant all privileges

Once you submit the form, you will have a new user and a dedicated database that shares the same name as your username.