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