Configure MySQL Database and Manage Using Adminer on Raspberry Pi

After install LAMP Web Server on Raspberry Pi, you can proceed to configure and manage the database.

INTRODUCTION

After install LAMP Web Server on Raspberry Pi, you can proceed to configure and manage the database. To manage the database you need a software tool like phpMyAdmin or Adminer. However this tutorial will only cover for Adminer because it has more advantages compare to phpMyAdmin yet easy to install.

VIDEO

This video will show you how to configure MySQL database and manage using Adminer on Raspberry Pi.

COMMAND LINE

Run MySQL secure installation at Terminal.

sudo mysql_secure_installation

Run MySQL.

sudo mysql -u root -p

Create the database (mydb is refer to database name).

create database mydb;

Now grant database privileges to the new user.

GRANT ALL PRIVILEGES ON mydb.* TO 'idris'@'localhost' IDENTIFIED BY 'idris123';
  • mydb is refer to database name you create before.
  • idris is username (you can write any).
  • idris123 is password (you can write any).

For the changes to take effect, you will need to flush the database privileges.

FLUSH PRIVILEGES;

To exit database configuration.

quit

Restart Apache Web Server.

sudo service apache2 restart

Related Products

You can consider to buy the product from the list below.

Thank You

References

  1. Build a LAMP Web Server with WordPress
  2. How to set up a full web server on a Raspberry PI

Thanks for reading this tutorial. If you have any technical inquiry, please post at Cytron Technical Forum.

Leave a Comment

Your email address will not be published.

Share this Tutorial

Share on facebook
Share on whatsapp
Share on email
Share on print
Share on twitter
Share on pinterest
Share on facebook
Share on whatsapp
Share on email
Share on print
Share on twitter
Share on pinterest

Latest Tutorail

Display Temperature and Humidity on OLED using DHT22 and Arduino
Getting Started With Teensy Using Arduino IDE
Night Light
Arduino Device Tracker Using GSM GPS SIM7600E Module
Chocolate Box with Touch Sensor and Arduino
Scroll to Top