12
website login questions (programming.dev)

so im looking to make a login for a website using PHPmyadmin, im pretty new to the whole SQL PHP thing, i can get the tables setup and everything working for the most part, having some issues getting the session_start(); $DATABASE_HOST = ''; $DATABASE_USER = ''; $DATABASE_PASS = ''; $DATABASE_NAME = '';

part figured out, i know the host is the server IP/location, its the user/pass/database tags im confused about, there is an ANY account on my database admin page that can read data from the databases but is it possible to set it up so that way its an account that only has the ability to read the accounts table? like:

$DATABASE_USER = 'login'; $DATABASE_PASS = '*'; $DATABASE_NAME = 'Accounts';

also the database name need to be the name of the database not the table correct? stupid question but just want to be 100% sure i know how some languages can be lol.

also, is it possible to take a users public PGP key, encrypt a random string of text and serve it to them, and have them verify the text with their private key as a way to authenticate identity?

you are viewing a single comment's thread
view the rest of the comments
[-] myersguy@lemmy.simpl.website 3 points 1 year ago

Database name is the database name, not the table name

User is the user for your database. Look up how to create new users in phpmyadmin. You should be able to grant or revoke different accesses in phpmyadmin as well to achieve an account which can only read a specific table (search for information on grants)

Lastly, Id like to suggest you not write your own security techniques (auth, etc). Look up best practices and use them (JWT, OAuth, Session cookies, etc).

[-] Nemo@slrpnk.net 1 points 1 year ago

Seconding not writing your own security unless this is a learning excercise. That's the kind of thing you should absolutely do once or twice to be sure you understand it, and then use something that's had more eyeballs on it for your actual webapp.

this post was submitted on 01 Jul 2023
12 points (83.3% liked)

No Stupid Questions

35800 readers
212 users here now

No such thing. Ask away!

!nostupidquestions is a community dedicated to being helpful and answering each others' questions on various topics.

The rules for posting and commenting, besides the rules defined here for lemmy.world, are as follows:

Rules (interactive)


Rule 1- All posts must be legitimate questions. All post titles must include a question.

All posts must be legitimate questions, and all post titles must include a question. Questions that are joke or trolling questions, memes, song lyrics as title, etc. are not allowed here. See Rule 6 for all exceptions.



Rule 2- Your question subject cannot be illegal or NSFW material.

Your question subject cannot be illegal or NSFW material. You will be warned first, banned second.



Rule 3- Do not seek mental, medical and professional help here.

Do not seek mental, medical and professional help here. Breaking this rule will not get you or your post removed, but it will put you at risk, and possibly in danger.



Rule 4- No self promotion or upvote-farming of any kind.

That's it.



Rule 5- No baiting or sealioning or promoting an agenda.

Questions which, instead of being of an innocuous nature, are specifically intended (based on reports and in the opinion of our crack moderation team) to bait users into ideological wars on charged political topics will be removed and the authors warned - or banned - depending on severity.



Rule 6- Regarding META posts and joke questions.

Provided it is about the community itself, you may post non-question posts using the [META] tag on your post title.

On fridays, you are allowed to post meme and troll questions, on the condition that it's in text format only, and conforms with our other rules. These posts MUST include the [NSQ Friday] tag in their title.

If you post a serious question on friday and are looking only for legitimate answers, then please include the [Serious] tag on your post. Irrelevant replies will then be removed by moderators.



Rule 7- You can't intentionally annoy, mock, or harass other members.

If you intentionally annoy, mock, harass, or discriminate against any individual member, you will be removed.

Likewise, if you are a member, sympathiser or a resemblant of a movement that is known to largely hate, mock, discriminate against, and/or want to take lives of a group of people, and you were provably vocal about your hate, then you will be banned on sight.



Rule 8- All comments should try to stay relevant to their parent content.



Rule 9- Reposts from other platforms are not allowed.

Let everyone have their own content.



Rule 10- Majority of bots aren't allowed to participate here.



Credits

Our breathtaking icon was bestowed upon us by @Cevilia!

The greatest banner of all time: by @TheOneWithTheHair!

founded 1 year ago
MODERATORS