Hi @Philip209, welcome.
I just saw that you also left a post on the main site. I won’t bother replying to that one.
Setting the MySQL root password
The MySQL root password is set when you run this command:
sudo apt-get install mysql-server -y
And when you run this script, you’re given the option to change it again:
So, let’s say that you did write down your password correctly. Let’s have a look at these 2 scenarios which I stumbled across by pure chance one day. I think it’s something to do with either the version of MySQL or phpMyAdmin. The default version that gets installed depends on your Web Hosts default repositories.
Scenario A: Password Strength
You’re password is correct, but phpMyAdmin simply won’t let you log in. This is a conflict between what MySQL thinks is a “secure” password and what phpMyAdmin thinks is a “secure” password. So, if MySQL says the password is good but phpMyAdmin disagrees then it won’t let you in.
In this case you should run the
sudo mysql_secure_installation script again and update your password to something more secure.
Make sure that your MySQL root password password is:
- Longer than 16 characters
- Contains numbers
- Contains lower & uppercase characters
- Contains special characters
Scenario B: Security Protocols
When I was testing Ubuntu 18.04, it installed an updated version of phpMyAdmin that uses new security protocols. They kinda make sense, but they’re still a bit of a pain. One of those new protocols is not allowing the MySQL root user to login whether you enter the password or not.
In this case, you’ll want to create a magento user/database for MySQL. Rather than repeat myself, I’ll link to this post I wrote when I originally came across the issue that contains the instructions you need.
Hopefully, one of those scenarios relates to your situation and solves it.