error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock

To find all socket files on your system run: My Mysql server system had the socket open at /var/lib/mysql/mysql.sock Once you find where the socket is being opened, add or edit the line to your /etc/my.cnf file with the path to the socket file: Sometimes the system startup script that launched the command line executable specifies … Read more

How to download a file over HTTP?

Use urllib.request.urlopen(): This is the most basic way to use the library, minus any error handling. You can also do more complex stuff such as changing headers. On Python 2, the method is in urllib2:

C++ error: terminate called after throwing an instance of ‘std::bad_alloc’

This code has 3 holes: First hole: int numEntries. Later you do: ++numEntries; You increment unspecified value. Not sure if it’s UB, but still bad. Second and third hole: And numEntries has unspecified value (first hole). You use it to initialize length and size – that is Undefined Behaviour. But let’s assume it is just some big number – you allocate memory … Read more

Using group by on multiple columns

Group By X means put all those with the same value for X in the one group. Group By X, Y means put all those with the same values for both X and Y in the one group. To illustrate using an example, let’s say we have the following table, to do with who is attending what subject at … Read more

C++ Vector of pointers

It means something like this: Then you add to the vector as you read lines: Remember to delete all of the Movie* objects once you are done with the vector.