Configuring mysql on Ubuntu 18 (password problem) after LAMP installation

Since Ubuntu 18 no longer asks for a password during installation, the following is required. Do the following and follow all steps – this will set the root password for the console:

sudo mysql_secure_installation

In order to be able to log in via a CMS or Phpmyadmin, the following is necessary:

sudo mysql

Add a new user (replace username with another name and replace password with your password):

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

Reload the user tables:

FLUSH PRIVILEGES;

You can now log in to phpmyadmin with your username and password.