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.

1 thought on “Configure MySQL Database and Manage Using Adminer on Raspberry Pi”

  1. Pingback: Raspberry Pi Lesson: LAMP Web Server « Blog Kejuruteraan Dan Teknologi

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

Control Servo With Gesture Using ESP32 and Arduino
Send Sensor’s Data to ThingSpeak Using ESP32
Basic Usage of iMAX B6AC LiPo Charger
Colourful Bed Lamp Using Tilt Sensor on Maker UNO
Dot Matrix Clock With NTP Server Using ESP32
Scroll to Top