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:

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

3. Apply the privileges:

   FLUSH 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:

   SHOW DATABASES;

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.

Conclusion

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.