Question

5

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

rated 0 times [ 5] [ 0] / answers: 1 / hits: 97101 / 3 Years ago, sat, may 22, 2021, 2:52:25

I know that some users may say that this is a duplication but seriously I have combed the answers and those on the internet for over half a day and I am so frustrated i am going to explode.

Now that therapeutic explanation is done, I have installed MySql Server and MariaDb 10 from the Ubuntu repositories on Ubuntu 12.04 LTS and input the root password when it is installing[When the pink screen appears and prompts for the root password] and the installation goes through as smoothly as a knife through butter.

Now the real frustration begins in either of the below 2 scenarios:

When I enter the sudo /usr/bin/mysql_secure_installation command nd am prompted to enter the root password

or

2.When I enter the mysql -u root -p command and am prompted for the password.

Please I really need help on this - I have lost count of the number of times I have had to uninstall and reinstall either MySQL or MariaDb because this pain in neck erf an error.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

ranquctive

Add To Favorites

Follow

Total Points: 391

Total Questions: 103

Total Answers: 104

Location: South Sudan

Member since Thu, Feb 4, 2021

3 Years ago

ranquctive questions

1 Setting up the $DISPLAY environment variable on WSL2 to use Qt software

Wed, Jul 6, 22, 19:44, 2 Years ago

1 Run shell script as root user while being a regular user

Sun, Apr 10, 22, 23:19, 2 Years ago

1 Dell Precision 3660 shuting down for overheating

Sun, Nov 21, 21, 22:40, 3 Years ago

1 Gnome shell restart is not working in Ubuntu 22.04 using ALT+F2

Thu, Oct 14, 21, 08:23, 3 Years ago

1 How do I check if command failed... with a pipe?

Sun, Apr 3, 22, 17:43, 2 Years ago

View All

answered 3 Years ago urvedcaly · Accepted Answer

I think I may have figured out the issue - It has to do with the long password.I think that this should reported as a bug to MySQl and MariaDB developers because on installation you can create a password with over 100 characters but when you try to login to MySQl or MariaDB when it is in production you get the above error.

So glad I figured this out after so much pain - surprising really that this has not been identified as a bug considering how many years MySQL has been in production.

So basically one resolution is to go through the following steps to resolve the above issue:

Start with a blank password on a non-production server and is if it works

If you are successful with step 1 then proceed with securing your mysql installation by typing the follwing command: sudo /usr/bin/mysql_secure_installation and try entering a more complex password - comination of lowercase letters, numbers, symbols and uppercase letters of at least 8 characters should be fine.

I recommend starting with 8 and move upwards till you reach a ceiling with the number of characters you can enter.

The above should be a step in the right direction to getting your MySQL server secured.