If you just installed MySQL image on Docker and then try to access the container and run MySQL command and you get the below 1045 (2800) error,
% mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
% mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Fix:
You need to go to Docker desktop and check for the logs for the MySQL container, you should see the generated root password,
[Entrypoint] Database initialized
mysqld will log errors to /var/lib/mysql/b05e275b7577.err
mysqld is running as pid 68
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
[Entrypoint] GENERATED ROOT PASSWORD: asdQ52ERv=;13AB@j*o=Y2O2j.pl6?@2
You can also access the logs using command: docker logs container_name
Now copy this MySQL root password and run the MySQL command again,
% mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30
Server version: 8.0.30
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
More Posts related to MySQL,
- MySQL Workbench could not detect any MySQL server running. This means that MySQL is not installed or is not running.
- Fix: pip install mysqlclient error: subprocess-exited-with-error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL: Error Code: 1175 You are using safe update mode
- Display List of Databases in mysql Command Line
- How to install MySQL Workbench on Mac (M1/M2)
- [macOS] Fix: MySQL ERROR 2002 (HY000): Cant connect to local MySQL server through socket /tmp/mysql.sock (2)
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- MySQL: How to know which Database Schema you are on in Terminal
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL Workbench - Connection Warning - Incompatible/nonstandard server version or connection protocol detected
- MySQL: How to Select Database via Terminal/Command Line
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Connection Failed: 1130 PHP MySQL Error
- Identify MySQL version in MySQL Command Line Prompt
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- How to Create Database in MySQL
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to query database table names [MySQL/Oracle/SQL Server]
- How to clear MySQL Console Screen
More Posts:
- Fix: ReferenceError: require is not defined in ES module scope [Node] - JavaScript
- Fix - JioCinema Something Went Wrong Please Try Again Error 8001 while streaming IPL Cricket Live - HowTos
- Call a Stored Procedure using Java JDBC CallableStatement Example - Java
- Generate Maven Project Dependency Tree using MVN Command - Java
- What Java version is used for Minecraft 1.18 - Java
- Google Colab: How to read file from Google Drive - Google
- Shortcuts: How to Toggle Word Wrap in Visual Studio Code (VS Code) - Shortcuts
- How to Whitelist IP Address on GoDaddy Hosting? - HowTos