How to install phpMyAdmin on Ubuntu 18.04

March 11, 2019 Post tags: how | ubuntu | linux | phpmyadmin | mysql |

What is phpMyAdmin?

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.

Prerequisites

You need to have an Ubuntu 18.04 server with a non-root sudo-enabled user account and a MySQL server.

Don't have a server? Rent one for cheap on services: AWS, DigitalOcean, GoogleCloud

If you need help you can contact us.

Setup phpMyAdmin

Install phpMyAdmin from the default Ubuntu repositories:

sudo apt update
sudo apt install phpmyadmin php-mbstring php-gettext
sudo phpenmod mbstring
sudo systemctl restart apache2

Adjusting User Authentication and Privileges:

sudo mysql

Configure the root account to authenticate with a password don't forget to change "password" word to your password:

SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
exit

Product - ORI PWA

Speed up your business with PWA application. PWA can be your website and mobile application for both Android and iOS.

We have taken special care to include everything you need. Reduce your headaches both during production and regular maintenance.

Our PWA can pull data from anywhere, custom RESTFUL api, Word Press, Magento, Drupal, Contentful, XML, JSON, spreadsheets and more. We can organize, display and process pulled data per your liking.

Do you want a hassle-free, modern and super fast website?

Find out more

Comments

ORI provides full business web identity creation service! Contact us