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 r...
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   ...
Read more
Image
Installing  mySQL connector to  connect python  with php myAdmin in Raspberry Pi . To run mySQL with python we need to establish connection between mySQL and python in Raspberry pi. We already install mysql with php myadmin . (if phpmyadmin is not install in your raspberrypi then visit  : https://aiworldofjuhi.blogspot.com/2019/02/how-to-install-mysql-on-raspberry-pi-3b.html ). now, go to command prompt or terminal in raspberry pi and install bellow library. Step 1 : $sudo apt-get update Step 2 : $sudo apt-get upgrade Step 3 : $sudo apt-get -y install python-mysql.connector After installing python-mysql.connector python is ready to work with mysql. here, An example of inserting data in php myadmin using python-mysql.coonector. Way: 1 import mysql.connector mydb=mysql.connector.connect(host='localhost',user='raspberry',passwd='juhi',database='chanchala') print ("working") mycursor=mydb.cursor() #mycursor.ex...
Read more