What is the proper way to install LAMP in elementary OS 5.0 Juno?

Question

I’ve recently done this. I just used php7.1 instead of 7.0

Problem:

So for mysql, I type root for the password as I cannot leave root password blank. Then I go to localhost/phpmyadmin, but I can’t login via username: root and password: root.

I’ve been looking at some guides here and there, but no cigar.

Though one thing I noticed is there currently is non for 5.0 Juno.

Can somebody help me out?

Answer 1

Since you have not deployed a site and their are easier options out there. I recommend removing everything you have done thus far and selecting one of the two options below.

Remove previous LAMP installs

sudo apt-get purge mysql* apache* php*
sudo apt autoremove && sudo apt autoclean

Use tasksel to install LAMP

sudo apt install tasksel
sudo tasksel install lamp-server

Firstly grab and install EE:

sudo wget -qO ee rt.cx/ee4 && sudo bash ee

Now for a LEMP stack run:

sudo ee site create example.com

For a Wordpress LEMP install:

sudo ee site create example.com --type=wp

Answer 2

When you first install mysql server and the installation does not ask for root password, it takes auth_socket as default plugin for mysql root user, which does not allow root connections without sudo. You can test this if you run mysql -u root(ERROR 1698: Access denied for user 'root'@'localhost') and sudo mysql -u root.

There are two solutions:

Change default plugin for root user

It is already explained here. The mentioned error will appear in other programs that can use mysql root user too, therefore this is a all-in-one way to solve it

Create a new user with root privileges (It is not recommended that you use mysql root user for common usage, so i recommend this option)

Enter into mysql with sudo (no password needed)

sudo mysql -u root

Create a new user (replace phpmyadmin_user and password with yours)

mysql> CREATE USER 'phpmyadmin_user'@'localhost' IDENTIFIED BY 'password';

Grant root privileges to the new user (You can also specify what databases and tables you're granting privileges to with databases.tables, * is a comodin)

mysql> GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin_user'@'localhost';
mysql> FLUSH PRIVILEGES;

Now you should be able to login into phpmyadmin with the new user/password.

Answer 3

As Juno has an Ubuntu 18.04 base, the following might work. (Mariadb)

sudo apt install mariadb-server mariadb-client
sudo mysql_secure_install

This will set a root password. You may have to use

sudo mysql -u root -p

there onwards.

Answer 4

For some reason, in Ubuntu 18.04, the MySQL workbench will also have the same issue, try this and it works for me. Reference

Answer 5

The way I use the mysql server on my local computers is by mysql_native_password authentification method.

0. Preparation. If you have any errors and no databases to keep I recommend starting clean. For this reason lets fisrt remove all packages and databases with:

sudo apt purge mysql*

if you do not have the purge command, you can install it by sudo apt install purge

1. Install mysql server

sudo apt install mysql-server

2. Remove dangerous defaults and lock-downs of the database

sudo mysql_secure_installation

2.1 VALIDATE PASSWORD PLUGIN. There are two options here, to make my life easier I use the No option and always chose a strong password. There is an option to use it with Yes, and configuration instructions if you follow the link I will provide later, but I never succeed to have phpMyAdmin running if I use Yes.

2.2 Remove anonymous users: In most cases you do not need them so I recommend Yes

2.3 Disallow login remotely: I use Yes, because I do not want remote logins to my local database, but if you plan to do this via SSH for example, you better choose No. Otherwise, Yes is more safe and it always can be changed using the same secure instalation wizard

2.4 Remove test database and access to it: Yes. Unless you need it for some reason you better remove it.

2.5 Reload privilage tables now: Yes, because you want the changes made already to be active.

3. Switch authentification method of root user from auth_socket to mysql_native_password. This is necessary if you wish to not using the sudo command every time you login into mysql database, also to use native phpAdminLogin with the same root password. First you need to login into mysql using the auth_socket:

sudo mysql

Because you will login into mysql command line interface, the shell prompt will be mysql>. Make sure to replace the string your_root_password below with the password you want to use for the mysql root account, but put it in inside the ' '.

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

Use the next command to flush the privileges:

FLUSH PRIVILEGES;

In order to leave the mysql command interface and go back to bash console execute:

exit

From now on you will be able to login using mysql -u root -p but if you try sudo mysql -u root -p you will have an error because the authentification method is changed from auth_socket to mysql_native_password.

On the next link you can see a complete guide how to install LAMP on ubuntu 18.04, with more detailed explanation of the mysql part, including options if you choose VALIDATE PASSWORD PLUGIN to be Yes. I do not say it is wrong to be done this way, but I never succeeded to make it work using the password validation.

https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-ubuntu-18-04#step-2-%E2%80%94-installing-mysql

This complete guide above I use every time when I face any problems during installing LAMP on Ubuntu 16.04 and 18.04 based operation systems. The version on the link is for ubuntu 18.04, but it actually is an updated version for the ubuntu 16.04 from the same website I have used with Loki and Ubuntu 16.04. Good luck!