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--

Install Lamp Server on Linux

Install Lamp server

sudo apt install apache2
sudo apt install mysql-server
sudo apt install php-pear php-fpm php-dev php-zip php-curl php-xmlrpc php-gd php-mysql php-mbstring php-xml libapache2-mod-php
sudo service apache2 restart

check php
php -r 'echo "\n\nYour PHP installation is working fine.\n\n\n";'



--30--