Is there a possibility to run a few instances of a game to test a multiplayer game on my own ?

Please correct me if i am wrong:

If i want a game to be able to influence certain variables in a SQL database, the database passwort has to be saved either on the webpage or in the game code. (like in the https://www.scirra.com/tutorials/525/si ... l-database tutorial ,where the password would be saved in login.php)

But could'nt anyone so inclined just read the password out and get access to the SQL database ?

Is there a way to influence SQL database values without entering the password ?

Or can the password made invisible somehow ?

Or doens't it matter as long as the user hasnt access to the webpage password ?

As you see i am quite new to this topic.

Thank you for an answer.

I surfed a bit through the forums and found out that this could be possible by creating arrays and sending them with the proper command to an sql database. Not quite sure though.

Also, it hasn't to be hostside...

it could also save that information on some file on a website - some datas like : position, inventory items,... - so that the player can't edit them himself, but the game will request it anytime it starts from a distance location.

I want to create a game, where data is saved and requested hostside.

E.g. If i pick up a coin as peer the information will be sent to host. There it is saved (to file) (sth like coin=coin+1)

Now if the peer (e.g.) opens the inventory the amount of coins shall be requested from the host.

Is that possible ?