PHPMyAdmin is a web based tool to manage your MySQL Server. This tool will help us to connect to MySQL/MariaDB Server and then perform various administrative tasks. For example, you can create new users, edit, delete users, create, edit and delete databases, tables, perform queries. You can also perform backup to the MySQL Server using PHPMyAdmin. This tutorial is going to show you how to install PHPMyAdmin on Ubuntu 18.04 Bionic Beaver.
Steps to Install PHPMyAdmin on Ubuntu 18.04
Open Terminal or connect to Ubuntu Server via ssh. From Windows, you can use Putty or Termius.
Step 1. Install MySQL Server
On the console, execute the following command:
sudo apt install mysql-server
Step 2. Start & Secure MySQL Server
Once MySQL Server is installed, lets start it with this command
sudo systemcl start mysql
Now, secure it
You will be asked to change the root password and some other things.
Step 3. Install PHPMyAdmin
Use this command to install phpmyadmin on Ubuntu 18.04
sudo apt install phpmyadmin
During installation, you will be asked for several questions such as the following. In this case, I use Apache web server.
You will also need to configure database
Connecting to PHPMyAdmin
Once the installation completed, open web browser and type:
If you are connection from other computer, use the server IP address instead of localhost
The new version of MySQL Server requires sudo to connect to the console. So, it is not possible to connect to PHPMyAdmin using root user. You will get the following error when login using root user:
#1698 - access denied for user 'root'@'localhost' phpmyadmin
To solve this, we need to create a new MySQL user and give proper privileges to it. So, lets do it.
#Login to MySQL Console sudo mysql -u root -p Enter password: #Create New User mysql> CREATE USER manjaro@localhost identified by '12345'; Query OK, 0 rows affected (0.00 sec) #Grant privileges to new user GRANT ALL PRIVILEGES ON *.* TO 'manjaro'@'localhost' identified by '12345' WITH GRANT OPTION; FLUSH PRIVILEGES; EXIT;
Now you should be able to login to PHPMyAdmin web UI using the new user we created.
Now enjoy PHPMyAdmin