Introduction

This article is completely not having a slight any different with the one in this link. It is an article where the title of it is ‘How to Solve Error Message ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)’. It has the same title with this article but a slight different ending to it. The only different is in this part ‘using password: NO’. It is obvious that this part indicating that there is no action for inserting password when the ‘Enter password: ‘ prompt appear. On the other hand, in the article in this link , there is an action which is inserting the password. But there is a similar situation when solving the problem. It is already explained in detail in the article in this link.

So, in order to solve the error message appear as in the title of this article, just follow the solution exist in the article in this link. But in order to give some explanations before getting on that link, the actual situation is actually exist as follows :

1. There has been a manual installation of MySQL Database Server. The file installer exist in the download link of MySQL Database Server. It exist in this link . The source file installer is ‘mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz’.

2. Extracting the compressed file source installer to a specific location. In this context, it is in ‘/opt/mysql/temp/mysql-5.7.28-linux-glibc2.12-x86_64’. Create a new initialization script using the template exist in the MySQL source installer folder. Copy the file mysql.server exist in ‘/opt/mysql/temp/mysql-5.7.28-linux-glibc2.12-x86_64/support-files/’ into ‘/etc/init.d’.

3. Create also the MySQL configuration file which is normally has the name of ‘my.cnf’.

Solution

Finally, after starting the service of MySQL Database Server and also trying to access the MySQL Command Console, the error appear. After just simply pressing enter upon the appearance of ‘Enter password: ‘ prompt, the error appear. The solution for the above problem is quite simple as it shows in this link. Just set the ‘root’ password by disabling the authentication method. After that try to reset it again before MySQL Database Server can functionally perform normal.