Most Common Error while Installing PHPMyAdmin Solved on Ubuntu 18.04

Here is the most common error we can find while installing a myphpadmin. Let's Solve them.

Error: The requested URL /PHPMyAdmin was not found on this server.
 

Solution:

Step 1: sudo -H nano /etc/apache2/apache2.conf

Step 2: Then add the following line to the end of the file:

Include /etc/phpmyadmin/apache.conf

Step 3: Then restart apache:

/etc/init.d/apache2 restart

Error : #1698- Access denied for user 'root'@'localhost'

Solution :

sudo mysql -u root 

mysql> USE mysql;

mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';

mysql> FLUSH PRIVILEGES;

mysql> exit;

$ service mysql restart

Error : # 1045 - Access denied for user 'root'@'localhost'(using password: YES)

Solution :

sudo mysql

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

sudo mysql

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

mysql> FLUSH PRIVILEGES;