NOTE: THIS IS FOR SQLITE, NOT MYSQL, USE PHPMYADMIN FOR MYSQL.
Please also note: there are definitely other ways to access/modify SQLite database, but this is the way how I do it.
Step 1:
You need to download SQLite Expert Personal: SQLite Expert - A powerful administration tool for your SQLite databases
Step 2:
Install it, then run it.
Step 3:
At the top left corner, click the button that says "Open Database".
Alternatively, you can go to File -> Open Database.
Step 4:
Then browse to your server folder, then at the bottom right corner of the window, change file type to "All Files (*.*)".
Step 5:
Now you can see forgottenserver.s3db, open that.
Done!, you have now loaded the database! You're free to modify things.
If you want to modify things, like the account type for your account, all you need to do is click the table on the left side.
Then click the "Data" tab at the top
Then double-click whichever line you want to modify.
A new window will pop-up, change any value necessary!
Just keep note, if you are using the 0.2.15, your server needs to be shut down before changing anything in the database.
You do not need to save any changed data, it is automatically updated in real time.
Good luck!
Please also note: there are definitely other ways to access/modify SQLite database, but this is the way how I do it.
Step 1:
You need to download SQLite Expert Personal: SQLite Expert - A powerful administration tool for your SQLite databases
Step 2:
Install it, then run it.
Step 3:
At the top left corner, click the button that says "Open Database".
Alternatively, you can go to File -> Open Database.
Step 4:
Then browse to your server folder, then at the bottom right corner of the window, change file type to "All Files (*.*)".
Step 5:
Now you can see forgottenserver.s3db, open that.
Done!, you have now loaded the database! You're free to modify things.
If you want to modify things, like the account type for your account, all you need to do is click the table on the left side.
Then click the "Data" tab at the top
Then double-click whichever line you want to modify.
A new window will pop-up, change any value necessary!
Just keep note, if you are using the 0.2.15, your server needs to be shut down before changing anything in the database.
You do not need to save any changed data, it is automatically updated in real time.
Good luck!
Last edited: