KenoKivabe

Your Essential Queries

Author
Md Mojahedul Islam
27 Jul, 2022

How To Install Mysql Phpmyadmin


We'll See How To Install & Configure Mysql And phpmyadmin In Linux Easily:

1) Open Terminal

2) Update packages:

  1. sudo apt update && sudo apt upgrade  

3) Install Mysql Server

  1. sudo apt install mysql-server  

4) Install phpmyadmin

  1. sudo apt install phpmyadmin  

You'll see a window like below :

Press Enter

Press "Tab" to select OK
Press Enter
A password set window will appear
Type your password
Press Enter
Retype your password
Press Enter

5) Login to root mysql

  1. sudo mysql  
6) Run sql to create new user
  1. CREATE USER 'sammy'@'localhost' IDENTIFIED  BY '123456'; 

7)  Run sql to grant privileges for the user 

  1. GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost';  

8) Exit mysql

  1. exit;  

9) Make phpmyadmin accessible to http://localhost/phpmyadmin

  1. sudo ln -s /usr/share/phpmyadmin /var/www/html/  

10) Visit http://localhost/phpmyadmin and login using your user & password

Share:

Related Post

Share Post:

© 2024 kenokivabe.com