Category: Database

Reset MySQL Root Password in CentOS

In your development work, there are sometimes you forgot the mysql root password so you cannot make any system-level change to the mysql server. This quick tutorial tells you how …

Select random records in MySQL

There are some case we need to select random records in mysql. The normal way I did see many developers have used is ORDER BY RAND(). But they might not …

50 Top Open Source Tools for Big Data

Whenever analysts or journalists assemble lists of the top trends for this year, “big data” is almost certain to be on the list. While the catchphrase is fairly new, in …

Popular NOSQL databases comparison

1. Quick Comparison While SQL databases are insanely useful tools, their monopoly in the last decades is coming to an end. And it’s just time: I can’t even count the …