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

확인 범위

이 문서는 화면 또는 로그에 표시된 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 문구가 MySQL 공식 원문의 항목과 일치하는지 확인합니다.

원문 발췌

ectory under the data directory. (The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the mysql database directory. If not, initialize the data directory. After doing so and starting the server, you should be able to connect to the server. After a fresh installation, if you try to log on to the server as root without using a password, you might get the following error message. $> mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It means a root password has already been assigned during installation and it has to be supplied. See Section 2.9.4, “Securing the Initial MySQL Account” on the different ways the password could have been assigned and, in some cases, how to find it. If you need to reset the root password, see instructions in Section B.3.3.2, “How to Reset the Root Password”. After you have found or reset your password, log on again as root using the --password (or -p) option: $> mysql -u root -p Enter password: However, the server is going to let you connect as root without using a password if you have initialized MySQL using mysqld --initialize-insecure (see Section 2.9.1, “Initializing the Data Directory” for details). That is a security risk, so you should set a password for the root account; see Section 2.9.4, “Securing the Initial MySQL Account” for instructions. If you have updated an existing MySQL installation to a newer version, did you perform the MySQL upgrade procedure? If not, do so. The structure of the grant tables changes occasionally when new capabilities are added, so after an upgrade you should always make sure that your tables have the current structure. For instructions, see Chapter 3, Upgrading MySQL. If a client program receives the following error message when it tries to connect, it means that the server expects passwords in a newer format than the client is capable of generating: $> mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client Remember that client programs use connection parameters specified in option files or environment variables. If a client program seems to be sending incorrect default connection parameters when you have not specified them on the command line, check any applicable option files and your environment. For example, if you get Access denied when you run a client without any options, make sure that you have not specified an old password in any of your option files! You can suppress the use of option files by a client program by invoking it with the --no-defaults option. For example: $> mysqladmin --no-defaults -u root version The option files that clients use are listed in Section 6.2.2.2, “Using Option Files”. Environment variables are listed in Section 6.9, “Environment Variables”. If you get the following error, it means that you are using an incorrect root password: $> mysqladmin -u root -pxxxx ver Access denied for user 'root'@'localhost' (using password: YES) If th

확인 절차

1. 현재 화면 또는 로그에서 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 문구를 확인합니다.
2. 위 원문 발췌와 문구를 비교합니다.
3. 문구가 일치하면 이 문서의 출처 링크에서 적용 환경과 원문 전체를 확인합니다.

주의

이 문서는 문구 식별 범위로 제한합니다. 출처가 직접 설명하지 않는 원인, 설정 변경, 권한 변경 또는 복구 절차를 이 문서만으로 실행하지 마십시오.