
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.
Be the first to comment