Using phpMyAdmin to Manage Your SQL Database
Introduction
This article provides a guide on using phpMyAdmin to manage your Database if you have chosen a game server package that includes a database. phpMyAdmin is a web interface tool that allows you to access and manage your MySQL/MariaDB database.
Logging in to phpMyAdmin
-
Locate your login credentials: You should have received your login information for your database via email. This email will include your username, password, and the server address for your control panel.
-
Access your control panel: Open a web browser and navigate to the server address provided in your welcome email. This will typically be in the format "AB-XYZ-GAME-01.node.pedal.host:8081" (replace "AB-XYZ-GAME-01" with your actual node).
-
Enter your database credentials:
- In the "Server" field, enter "db" (this is important for database connection).
- In the "Username" field, enter the username provided in your welcome email.
- In the "Password" field, enter the password provided in your welcome email.
-
Click "Go" to log in to phpMyAdmin.
Managing Your Database
Once logged in to phpMyAdmin, you will see a list of databases on the left-hand side. Your database will likely have a name that starts with "beammp_". Click on this database name to see a list of tables within your database installation.
Important Note: Modifying your database directly through phpMyAdmin is generally not recommended for users who are not familiar with SQL queries. Making mistakes in your queries can potentially damage your database installation.
Need Help?
If you require assistance with managing your database or have any questions, please contact PedalHost's support team.
