ERROR 1045 (28000) – MYSQL Connection Error




MYSQL Connection Error – ERROR 1045 (28000) – while connecting to MYSQL Server

mysql server stopped working at times due to some internal issue,  ERROR 1045, causing trouble in connecting the MYSQL SERVER. We can try following below steps to sort the problem.

I have tried these steps and got the solution

ERROR 1045

ERROR 1045 SOLVED

Follow Below Steps :

step 1: stop MYSQL

sudo /etc/init.d/mysql stop

Step 2:start up MySQL in safe mode, so you’ll skip the privileges table:

sudo mysqld_safe –skip-grant-tables &

Step 3: Login with root:
mysql -uroot

Step 4:  use database mysql

use mysql;

Step 5: Reset the password for the root user using the following command

update user set password=PASSWORD(“YOURPASSWORDHERE”) where User=’root’;

flush privileges;

Step 6 : quit
Step 7 : stop / start the mysql services
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start

Step 8 : Try login again with mysql using new password

mysql -u root -p

Follow the above steps to get the issue resolved  ERROR 1045. Share your inputs in case of an issue.

Also Click to  Read: SSH without password   and  Perl Interview Questions




Leave a Reply

Your email address will not be published. Required fields are marked *