Immerse yourself in an unparalleled web universe with our innovative hosting solutions !

Explore reliable, secure, and high-performance options tailored to all your online needs.

All our web hosting solutions

Discover unmatched power with our innovative and tailored VPS servers !

Experience freedom and power with our VPS, designed to elevate your projects to new heights !

All our VPS servers

Optimize your bots with our dedicated, powerful, and tailored hosting !

Experience smooth management and optimal performance with our bot hosting.

All our bot offers

Boost your game servers with our specialized and efficient hosting !

Dive into the ultimate gaming experience with our optimized and powerful hosting !

All our Minecraft offers

Guide for Using Ouiheberg MySQL Services

This tutorial will guide you through the steps necessary to use the MySQL offerings from Ouiheberg. We will see how to create an admin user and a database using the console on Ouipanel.

Step 1: Accessing Ouipanel

  1. Login to your Ouipanel account

    • Access your Ouipanel account
    • Enter your credentials to log in.
  2. Access your server

    • Once logged in, select your server from the list of available servers.
    • Click on the server to access its management console.

Step 2: Start the Server

If your server is marked as "offline," start it by following the steps below:

  1. Click the green "Start Server" button in the management console.
  2. Wait for the server to be marked as "online."

Step 3: Create a MySQL Admin User

To create an admin user for your remotely accessible MySQL database, follow these steps in the CLI console of Ouipanel. You are already connected to MySQL via the console.

  1. Create a new admin user: Replace admin_user and strong_password with your desired username and a secure password.

    CREATE USER 'admin_user'@'%' IDENTIFIED BY 'strong_password';

  2. Grant all privileges to the admin user:


  3. Apply the privileges:


Step 4: Create a Database

After creating your admin user, you can now create a database:

  1. Create a new database: Replace my_database with the name of your database.

    CREATE DATABASE my_database;
  2. Verify the database creation:


Step 5: Usage and Management

Your database is now ready to use. You can manage your databases and users using standard MySQL commands or by using database management tools such as:

  • phpMyAdmin: A popular web tool for managing MySQL. You can use phpMyAdmin Online to access and manage your databases.
  • HeidiSQL: A database management tool for Windows, ideal for managing your MySQL and MariaDB databases. You can download and use it from HeidiSQL.


This tutorial has shown you how to set up and manage a MySQL database using the services from Ouiheberg. By following these steps, you can easily create users and databases via the Ouipanel CLI console and make them remotely accessible.

OuiHeberg SARL logo
Author Name

More from the article