I took up programming a couple of months ago (alongside my day job) and am struggling with a couple of basic concepts. Currently, I'm trying to learn how to build a database based PHP login/logout for a web app.
Can anyone help me understand the concept of database users? The way I see it, there is:
- a database server (which serves all the databases created, sort of like an "OS serves all the apps installed")
- all the databases, with their tables inside
- users (? this is where it gets confusing for me - how many and which users do I need?, what are basic good practices?)
- users from the table "users", which will get into this table by registering on the website are not the same as users that the app uses to connect to the database? Or are they?
I apologize, I understand that these are basic concepts but I find the available web tutorials lacking in good concept explanations. Everyone seems to want to jump right into the coding part asap whereas I find that programming is more about ideas and concepts and then about syntax and languages.
Many thanks for any reply! Alex