mysqladmin: connect to server at ‘localhost’ failed

Short version: If your MySQL user root needs a password to connect, it might be a good idea to have mysqladmin provide that password 😉 Longer version: Your MySQL user root seems to need a password to connect setting the mysql root password new But mysqladmin tries to connect without a password ‘Access denied for user ‘root’@’localhost’ (using password: NO)’ And mysqladmin does that because you’re not … Read more

Difference between numeric, float and decimal in SQL Server

use the float or real data types only if the precision provided by decimal (up to 38 digits) is insufficient Approximate numeric data types(see table 3.3) do not store the exact values specified for many numbers; they store an extremely close approximation of the value. (Technet) Avoid using float or real columns in WHERE clause search conditions, especially the = and <> operators. It is best to … Read more

ExpressJS : res.redirect() not working as expected?

The problem might not lie with the backend, but with the frontend. If you are using AJAX to send the POST request, it is specifically designed to not change your url. Use window.location.href after AJAX’s request has completed (in the .done()) to update the URL with the desired path, or use JQuery: $(‘body’).replaceWith(data) when you receive the HTML back from … Read more