How to inspect & modify your Physgun game server database data.
Connecting to your Physgun game server database to inspect or modify your data.
You might have come to a situation where, for some reason, you want to check any data located in your Physgun database or modify it; however, to do this, you will need to use some external software to connect, visualize & modify your database, in this guide, we will explain step-by-step how to do this using a software called DBeaver.
Downloading and installing DBeaver
You can download DBeaver latest version from their official site by clicking here DBeaver Download. Then, depending on your OS version, you just have to download the correct version, execute the file, and follow the installation instructions.
Connecting to your database.
Once you have installed DBeaver, we are going to proceed to connect to your Physgun database:
Go to your Physgun Game Panel -> Your server -> Manage -> Management -> Databases
Once you're in the Databases section, copy the details of the database that you want to connect to.
Open DBeaver > Database > New Connection > MySQL or press Ctrl + Caps + N
Click on Connect by Host.
Fill the connection details as the following:
Server Host -> Equals to "Connection" in the game panel
Database -> Equals to "Name" in the game panel
Username & Password -> Exactly equal in the game panel
After completing all these steps, click "Finish." It may pop up a window asking you to download the MySQL drivers. If that's the case, just click on "Yes".
After you connect to have added your database credentials, go back to the "Database Browser" in DBeaver and click on our database. Then, if you have followed all the steps, it should connect you to your database server. If not, please check the previous steps and ensure all your database credentials are correct.
Inspecting & modifying your database.
Once connected to your database server, double-click on the database name you want to check and double-click on "Tables." Doing this will display all the tables stored in your database, so if you want to check the data of these, just double click in the table, and then on the left side, when the table details appear, click on "Data," this will let you visualize all the table data and modify it. Keep in mind that if you modify any data, you will need to press Ctrl+S to get it saved into your database.
That's it! You might have thought that being able to inspect & modify the data of your free included databases was way more complex, but as you can see, the process is quite simple and can be done in a few minutes! **Keep in mind that you have to be very careful when modifying your database data, as this could break your server data.**
Updated on: 06/09/2023