[SOLVED] ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

If you’ve just installed mysql community server (in my case on Fedora 23) and you’re getting:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

The only thing that helped was:

edit your /etc/my.cnf file and add the line "skip-grant-tables" without quotes

After that you’ll be able to do:

 mysql -uroot -p

and type the new password. Then:

mysql> use mysql; mysql> UPDATE user SET password=PASSWORD("YOUR NEW PASSWORD HERE") WHERE User='root'; mysql> flush privileges; mysql> quit

By the way, if you login back into mysql and then try:

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

You might want to:

mysql> SET PASSWORD=PASSWORD('your new password');
Query OK, 0 rows affected, 1 warning (0.00 sec)


[SOLVED] How to capture localhost traffic on Windows

Most tools, like Wireshark and Netmon aren’t able to capture data that didn’t actually go out on the wire. Until now. Message Analyzer is the eventual replacement to Network Monitor and offers lots of new capture features. 

This is the download link: Download the tool.

And this is the blog explaining: