Lmarsden is a non-profit information site
Setting up a LAMP
The LAMP stack is the foundation for Linux hosted websites is the Linux, Apache, MySQL and PHP (LAMP) software stack.
The Four Layers of a LAMP Stack
Linux based web servers consist of four software components. These components, arranged in layers supporting one another, make up the software stack. Websites and Web Applications run on top of this underlying stack. The common software components that make up a traditional LAMP stack are:
Look for inet addr: 192.xxx.x.xxx which will show your Pi’s IP address (it could also start with 10.x.x.x or 172.x.x.x). Go to any desktop computer that’s connected to your local network and enter the IP address into your browsers address bar ie. http://172.18.0.xxx and hit Enter. You should be presented with the following Apache2 Debian Default Page:
Create an Admin account
You will see the following command line change from the RPi operating system to the MariaDB mysql server database.
To create new users we will need to create the user and then give them privilegers
Show all users on the sql server
Show grants to what databases
SHOW GRANTS FOR 'user_name'@'localhost';
Delete a user
DROP USER 'user_name'@'localhost';
DROP USER 'user_name'@'%';
DROP USER 'user_name'@'192.168.0.1;