Step 1: Access Ouipanel

Logging into your Ouipanel account

1. Access your Ouipanel account.
2. Enter your credentials to log in.

Accessing your server

1. Once logged in, select your server from the list of available servers.
2. 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 button "Start Server" 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 the steps below in the CLI console of Ouipanel. You are already logged into MySQL via the console.

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';

Grant all privileges to the admin user

GRANT ALL PRIVILEGES ON *.* TO 'admin_user'@'%' WITH GRANT OPTION;

Apply privilege changes

FLUSH PRIVILEGES;

Step 4: Create a database

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

Create a new database

Replace my_database with the name of your database.

CREATE DATABASE my_database;

Check the creation of the database

SHOW DATABASES;

Step 5: Usage and Management

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

• HeidiSQL — A database management tool for Windows, ideal for managing your MySQL and MariaDB databases. You can download and use it from HeidiSQL.

Conclusion

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