MySQL Error : 1045

1. Run Server ( WAMP / XAMPP )

2. Click on it in System Tray ( Right-Down corner of window )

3. MySQL > MySQL console

4. Type password and hit Enter 
or, If u don't have any just hit Enter 

5. If the screen shows, 
Welcome to the MySQL monitor. ...
then u have rightly entered in MySQL

6. Write the following commands sequentially,
mysql> use mysql
mysql> select user, host, password from user;
mysql> delete from user where host='localhost' and user='';
mysql> update user set password=password('') where user='root';
mysql> flush tables;
mysql> flush privileges;
mysql> quit

// all quotes are single quotes 

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s