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 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 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