Hi,
i have been struggeling with this install portion i’m so close but yet so far. to the problem: when i try to finnish step 2 adding a Database it gives a error wich i tried to solve but that didn’t work can you help me?
error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
You shouldn’t be using root to access your magento database. You should setup a separate username. This might be your issue. You should follow Chapter 4in this tutorial for best-practice.
Depending on your repository, you might not be allowed to access databases this way via a “root” user because MySQL have increased their security practices in their latest versions.
To me, “The server requested authentication method unknown to the client” screams incorrect mySQL username, password or database. Do these credentials work when you login via phpMyAdmin? Ubuntu 20 shouldn’t change anything.
I’ll be doing a clean install of 2.4.0 with Ubuntu 20 when it’s out. Probably sometime in Quarter 3 if I were to guess.
You can verify if you can login to MySQL as magento_user via the CLI by typing:
mysql -u magento_user -p
Then press enter followed by the magento_user password and hitting enter again. If you can’t access it then there may have been an issue creating the user.
As for 2.4.x, I’ve heard/seen nothing since December. It’s all pretty quiet. I think it was originally due in Q1. They normally do some sort of Webinar a couple of months before release. But I’ve received no emails about that either. One things for sure though, it’ll break stuff - It always does That’s why I wait a few versions after before adopting it like maybe 2.4.2. I’ll let everyone else find and fix the bugs first
Hmm… So, it’s not an issue logging in MySQL via CLI. I guess the security policies for MySQL could be “too strict”. Trying updating the security plugin for the magento_user and set a new password on that plugin:
sudo mysql -e "ALTER USER 'magento_user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'IamAveryStrongPassword483625@#£#@'"