Information	Description	Example
Host	MySQL server address	mysql-xxx.ouiheberg.com
Port	Connection port	3306
Database name	Your database name	s123_luckperms
User	Login ID	u123_abc123
Password	Password (click to display)	••••••••
JDBC URL	Java connection string	jdbc:mysql://...

💡 Tip: Click on the copy icon next to each field to quickly copy the value.

---

⚙️ Using the Database

Example for Minecraft (LuckPerms)

In the file plugins/LuckPerms/config.yml:

storage-method: MySQL

data:
  address: mysql-xxx.ouiheberg.com:3306
  database: s123_luckperms
  username: u123_abc123
  password: 'your_password'

Example for FiveM (server.cfg)

set mysql_connection_string "mysql://u123_abc123:[email protected]:3306/s123_esx"

💡 FiveM Tip: In OuiPanel, go to FiveM Configuration to automatically insert the MySQL connection string.

Example for Node.js

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'mysql-xxx.ouiheberg.com',
  port: 3306,
  user: 'u123_abc123',
  password: 'your_password',
  database: 's123_yourapp'
});

Example for Python

import mysql.connector

connection = mysql.connector.connect(
  host="mysql-xxx.ouiheberg.com",
  port=3306,
  user="u123_abc123",
  password="your_password",
  database="s123_yourapp"
)

---

🔧 Managing Your Databases

Access PhpMyAdmin

PhpMyAdmin is a web interface to view and modify your database content.

1. In the Databases section, locate your database
2. Click on the PhpMyAdmin button

3. You are automatically logged into the PhpMyAdmin interface. If not, please use the login credentials of the database created just now (information available in the information tab).
   Make sure you have selected the correct SQL server. In our case, it is MYSQL server 2 because the server host/address is mysql2.ouiheberg.com
   

With PhpMyAdmin you can:

• 📊 View tables and their data
• ✏️ Modify records
• 🗑️ Delete data
• 📥 Import a database (file .sql)
• 📤 Export a backup
• ⚡ Execute SQL queries

---

Change the password

If you want to regenerate the password for your database:

1. In the Databases section, locate your database
2. Click on the Rotate password button (circular arrow icon)

3. Confirm the action
4. A new password is generated automatically

⚠️ Attention: Remember to update the password in your plugins/scripts configuration after a rotation!

---

Delete a database

1. In the Databases section, locate the database to delete
2. Click on the Delete button (trash can icon)

3. Confirm the deletion

⚠️ Attention: This action is irreversible. All data will be permanently lost. Remember to export your data via PhpMyAdmin before deleting.

---

🔧 Troubleshooting

Database Connection Error

❌ Issue	✅ Solution
Access denied	Check the username and password
Unknown database	Check the database name
Can't connect to MySQL server	Check the host and port
Connection refused	Make sure the server is started

The plugin is not connecting

1. Check each information: host, port, database name, user, password
2. Watch out for special characters: if the password contains special characters (@, #, etc.), surround it with single quotes in the configuration files
3. Test with PhpMyAdmin: if PhpMyAdmin works, the credentials are correct
4. Restart the server after modifying the configuration

---

📝 Summary

1. Access "Databases" in the side menu
2. Click on "New database"
3. Name the database and validate
4. Copy the connection information (host, port, user, password)
5. Configure your plugin/application with this information
6. Restart the server