Introduction (LAMP Stack)
A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps.
To create a user in mysql with readonly access, following is the useful command.
Login with root access and use following commands.
CREATE USER ‘use’@’localhost’ IDENTIFIED BY ‘password’;
GRANT SELECT ON database.* TO user@’localhost’ IDENTIFIED BY ‘password’;