ERROR 1045 after Installation

I am using the XtraDB cluster for the first time in my Lap for my pharmacy app. I had this Error 1045 with the root command.

1 Like

Hi Charles, can you describe what you are trying to do in more detail? commands executed, etc.

1 Like

Hi charles,

Error 1045 is related to “Access denied” error.

When you install MySQL for the first time (on versions 5.7 and newer), a random password is written on the error.log which you need to use the first time to log into MySQL. Watch out for special characters as you might need to “quote” the password to be able to use it

Last, if you get locked out of MySQL you can use the last part of the following blogpost to reset “root” password: Fixing MySQL 1045 Error: Access Denied - Percona Database Performance Blog

Regards

3 Likes