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?