[SOLVED] Install Apache, MySQL, and PHP on Linux Mint 19

[waahah]

Hello,
I have a problem of not able to log into phpMyadmin with "root". I could only able to log in as username "phpmyadmin". However, when I logged in, there is no databases there beside info_schema and phpmyadmin. See pic*

How could I see MySQL database and other database I installed?

This is the step I used

• sudo apt-get update

• sudo apt-get install apache2

• sudo apt-get install mysql-server

• sudo mysql_secure_installation
  • Added password

• sudo apt-get install php libapache2-mod-php php-mysql

Install phpMyadmin

• sudo apt install phpmyadmin php-mbstring php-gettext

everything was installed. But could not login as root.

How could I see MySQL database and other database I installed?

Thanks

[kukamuumuka]

Did you set the PhpMyAdmin root-password when installing?

[waahah]

Yes, I did setup the phpMyadmin password. Before, after installing LAMP and phpMyadmin, I could login as "root" and see all databases, including mysql. Now I couldn't login as username "root" and could only login as username "phpmyadmin" with password. Also there were no database beside those two in the picture

[cacus]

Hi, i have the same problem.
Could you solve it?


EDIT: I've finally found the solution. The problem is the "root" user using auth_socket for authenticating, you should run this from "sudo mysql":

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';

Cheers!

[waahah]

Awesome. Thanks.