ERROR 1045 (28000) – MYSQL Connection Error

MYSQL Connect 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 to the solution

ERROR 1045


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 above steps to get the issue resolved  ERROR 1045 , share you inputs in case of issue is seen.

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 *

Translate »
[huge_it_videogallery id="2"]