I am able to setup Apache server post that - and I am able to install MySQL server. Later, when I am trying to switch MySQL password plugin and setup password - I am running in to issues and my password command is not getting executed as desired.
Even though, I am able to install phpMyAdmin - I am not able to login using the root password - which I created using the following command:
sudo mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'my password'"
I am only able to login using phpMyAdmin user name and not the root user name - which I originally created using the command prompt.
My Setup
Shared or Dedicated Server? VPS
Did your setup the server or install Magento yourself? I am trying to setup Magento by myself.
What are your server specifications? 3 GB RAM, Ubuntu 20.4, 3 CPU
What version of Magento are you using? Trying to install Magento 2.4
I tried reinstalling the server a few times and the issue is not going away even though I am starting afresh - I am running in to same issue again.
Any suggestions on how I can possibly rectify the issue? Kindly suggest.
That command you referenced normally works wonders for me. I wonder, when you run mysql_secure_installation are you setting up password strength or disabling it? I’ve had issues with this feature in the past so typically, I’ve got used to simply disabling this when prompted.
Thank you, Craig! I will test this new method as well.
Btw, the issue with MySQL got rectified after ensuring that I copy the command syntax properly.
Initially, I had issues mainly because of the syntax - I was copying from the notepad - and when I tried to paste the command - it did not get copied as desired resulting in an issue while creating the user account.