How can I deal with this error: Error no 1045: While trying to connect to MySQL.

Question

I have installed a GUI tool SQLYog Community edition for windows for MySQL. Previously, I installed MySql with XAMPP. The moment I tried to connect, it displays an error: Error No. 1045 Access denied for user ‘Rahul’@’localhost’ (using password: Yes)

How to deal with this error?

Answer 1

As I can see, it says access denied for Rahul @localhost . I have listed down few issues:

• There can be a chance that user Rahul does not exist at localhost.

• You might have entered the wrong password.

• You might have not started MySQL server. If it’s started, the port number is not 3306.

These were few of the basic techniques which can help you troubleshoot the stuff. 

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.