How to Install MySQL on Raspberry Pi 3B with phpMyAdmin

Python can be used in database application. one of the most popular database is MySQL. MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database.

This article provide installation steps of MySQL on raspberrypi 3B with phpMyAdmin. 

Open Linux Terminal:
$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get intall -t stretch apache2
$ sudo apt-get install -t stretch php7.0
$ sudo apt-get install -t stretch php7.0 -mysql

$ sudo nano /var/www/html/info.php

 Type below line in open info.php file

 <?php
phpinfo();

?>

 After adding above line save and exist from this file.
Now ,open the any internet browser and type your Raspberry Pi IP address in search bar.
my Raspberry pi  ip address is 192.168.108 .  

 192.168.108
192.168.108/info.php

 info.php page will open. now, reboot the Raspberry Pi.after rebooting Pi follow the bellow command in terminal.

$ sudo apt-get install -t stretch mysql-server
$sudo apt-get install -t stretch mysql-client

Again reboot the raspberry pi after installation of mysql server and mysql client.
next step is to install phpmy admin with some package configuration.

$ sudo apt-get install phpmyadmin

one message box will open with two option. select Apache2. press the ok button. set password and configure password again then give ok.



$ sudo apt-get install mysql-server
$ sudo apt-get mysql_secure_installtion
$ sudo mysql -u root -q
$ sudo apt-get install python install python-mysqldb
$ sudo mysql -u root -p
this commands will connect mysql with phpmyadmin. now open apache2.conf fig file and type bellow line in the end of file, save it and exit from file.

$sudo nano /etc/apache2/apache2.conf

include  /etc/phpmyadmin/apache.conf

now, starts the apache2 service.
$ sudo /etc/init.d/apache2 restart

Set all the privileges for the user "root"
$ sudo su
# mysql -u root -p
MariaDB[(none)]>GRANT ALL PRIVILEGESon*.*to'root'@localhost'IDENTFIED BY 'test';

MariaDB[(none)]>FLUSH PRIVILEGES;
MariaDB[(none)]>\q
#service mysql stop
#service mysql start

go through web browser and run the phpmyadmin

192.168.1.104/phpmyadmin/index.php

Select local host.Enter the i.d and password. Mysql will start with php myadmin.


Php myadmin webpage willlook like this with mysql.

Comments

Post a Comment

Popular posts from this blog

Image
Survey  on AI self-driving cars around the world What’s the future of personal transportation? Well, you’ll likely be spending a lot less time behind the wheel, for one. The rise of self-driving cars means that some scenes out of science-fiction flicks (movie: Total Recall  or  I, Robot ) are now reality—and even more will be available soon. What is self-drive car? Self-driving vehicles are cars or trucks in which human drivers are never required to take control to safely operate the vehicle. Also known as autonomous or “driverless” cars, they combine sensors and software to control, navigate, and drive the vehicle. An autonomous car is a vehicle that is capable of sensing its environment and navigating without human input. Autonomous cars combine a variety of techniques to perceive their surroundings, including radar, laser light, GPS, odometry, and computer vision. In August 1961, Popular Science reported on the Aeromobile 35B, an air-cushion vehicle (ACV) that was inven
Read more

Voice Recognition Using web camera and Google API - Raspberry pi 3B (python)

Voice Recognition Using web camera and Google API - Raspberry pi 3B (python).   I am trying to find a Speech recognition library similar to PySpeech that will work on a Raspberry Pi 3. Google API is best for speech recognition because google api use hidden markov model for recognition. there are steps given below for voice recognition  Required  module: 1. Raspberry pi model 3 B 2. Logitech  Web camera 3. Rasbian os installed SD card Hidden markov Model:  - Hidden markov model is used to convert speech into text and recognized it. - In HMM, speech signal is divided into 10-millisecond fragment. - Every fragment converted into power spectrum. - Then each power spectrum converted into frequency domain. - In last each frequency domain fragment converted into vector. this each vector compare    with google speech API vector. - Dimension of these vector usually small, sometime 10. More accurate system may have    dimension 32 or more. - This vectors are
Read more
Image
Real Time Face Detection using Haar Cascade Algorithm and cloning detected face. Haar  Cascade is a machine learning object detection algorithm used to identify objects in an image or video and based on the concept of  ​ ​  features proposed by Paul Viola and Michael Jones in their paper "Rapid Object Detection using a Boosted Cascade of Simple Features" in 2001. It is a machine learning based approach where a cascade function is trained from a lot of positive and negative images.   It is then used to detect objects in other images. The algorithm has four stages: Haar  Feature Selection Creating    Integral Images Adaboost  Training Cascading Classifiers OpenCV comes with a trainer as well as detector. If you want to train your own classifier for any object like car, planes etc. you can use OpenCV to create one. Its full details are given here:  Cascade Classifier Training . Here we will deal with detection. OpenCV already contains many pre-tra
Read more