Page 1 of 1

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

Posted: Sat Jul 14, 2018 9:46 pm
by 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

Re: Install Apache, MySQL, and PHP on Linux Mint 19

Posted: Sun Jul 15, 2018 1:43 am
by administrollaattori
Did you set the PhpMyAdmin root-password when installing?

Re: Install Apache, MySQL, and PHP on Linux Mint 19

Posted: Sun Jul 15, 2018 4:41 pm
by 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

Re: Install Apache, MySQL, and PHP on Linux Mint 19

Posted: Mon Jul 16, 2018 11:07 am
by 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!

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

Posted: Mon Jul 16, 2018 12:04 pm
by waahah
Awesome. Thanks.