Install mysql / mariadb on raspbian example

 

 

 

How to install MySQL database on raspberry pi

1 sudo apt-get install mysql-server.

2 sudo mysql_secure_installation. 5)Please hit Enter for current root password.

3 sudo mysql -u root -p. ...

4 show databases; ...

5 CREATE DATABASE Demo; ...

6 USE Demo; ...

7 CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin'; ...

8 GRANT ALL PRIVILEGES ON Demo.* TO 'admin'@'localhost';

 

Example and more details

how-to-install-mysql-database-on-raspberry-pi 

 

 

--30--

Installing lamp on a linux server (of course, the L is for that).

There is what seems to be a good page on this subject here

https://linoxide.com/linux-how-to/install-lamp-stack-ubuntu/

Installing lamp and webmin on raspbian

Another writeup on installing a lamp server setup on a Raspberry Pi.  Probably need a 3 or 3+ to have any real justification, YMMV

sudo groupadd -f -g33 www-data
sudo apt-get update
sudo apt-get install apache2 php5 libapache2-mod-php5
sudo apt-get install mysql-server mysql-client php5-mysql
sudo apt-get  install  phpmyadmin
sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl \

libpam-runtime libio-pty-perl apt-show-versions python 

webmin:

mkdir webmin
cd webmin
wget http://prdownloads.sourceforge.net/webadmin/webmin-1.580.tar.gz
gunzip webmin-1.580.tar.gz
tar xf webmin-1.580.tar
cd webmin-1.580
sudo ./setup.sh /usr/local/webmin

http://yourPiipaddress:10000 

*****************
another install page for raspbian
*****************
http://www.instructables.com/id/Adding-Webmin-to-manage-a-Raspberry-Pi/

-30-

Lamp server install link

Here is a nice LAMP server setup page.

Using and posting this from a 2" x 2" x 2" quad core cubox debian system.

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-debian

Will copy edit inline later on update.

use sudo apt-get -y install apache2 mysql-server mysql-client php5-cli phpmyadmin 
to get that running

Install mysql
Install apache2 (if not by default)
install php

if php is installed prior to apache you may need to install

libapache2-mod-php7.0 (or whatever php if earlier or later install)