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

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
waahah
Level 1
Level 1
Posts: 9
Joined: Tue Apr 10, 2018 11:53 pm

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

Post by waahah » Sat Jul 14, 2018 9:46 pm

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
Attachments
PhpMyadmin.png
Last edited by waahah on Mon Jul 16, 2018 12:05 pm, edited 1 time in total.

User avatar
administrollaattori
Level 15
Level 15
Posts: 5856
Joined: Tue Sep 03, 2013 4:51 am
Location: Finland
Contact:

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

Post by administrollaattori » Sun Jul 15, 2018 1:43 am

Did you set the PhpMyAdmin root-password when installing?

waahah
Level 1
Level 1
Posts: 9
Joined: Tue Apr 10, 2018 11:53 pm

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

Post by waahah » Sun Jul 15, 2018 4:41 pm

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
Level 1
Level 1
Posts: 4
Joined: Sat Nov 29, 2014 10:51 pm

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

Post by cacus » Mon Jul 16, 2018 11:07 am

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
Level 1
Level 1
Posts: 9
Joined: Tue Apr 10, 2018 11:53 pm

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

Post by waahah » Mon Jul 16, 2018 12:04 pm

Awesome. Thanks.

Post Reply

Return to “Software & Applications”