While it's not recommended, your comments cover enough ground that rather than make a long answer, I'll address them here. If my answer is unsatisfactory, you might want to create a new question, clarifying the specifics.
A star 3 or 5 times the size of our sun will gradually burn up its
hydrogen and collapse to form a black hole big enough to swallow the
earth
Stars don't operate that way. During the final stages, (red giant, helium flash, etc), stars lose a significant percentage of their matter into space. Our sun is expected to lose about half it's mass by the time it becomes a white dwarf. larger stars lose an even higher percentage so you need a much more massive star to end up with a black hole. About 8 solar masses to end up a neutron star and about 25 solar masses (same link) for a black hole, though a neutron star can accrue mass and become a black hole that way too if it's in a binary system.
I realize that's not precisely what you asked, but one of the problems with compression on this scale is you have to ask what you are compressing. Compressing fissionable materials can lead to explosive events that would resist the compression.
If you use iron, which won't create any new energy upon being very tightly compacted, then you have a relatively straightforward mass to size problem where you can estimate the pressure. 3 solar masses of iron should be sufficient to form a black hole by its own mass and gravity. It might even be a bit less than that, as it's never been observed and would vary some with speed of rotation and temperature. But 3.0 solar masses is close enough.
The force of gravity needed to crush the star to a singularity is $10^x$ joules
This isn't straightforward because it would vary with the initial mass you wanted to force into a black hole and the math gets very complex, involving equations based on the Pauli exclusion principle and neutron degeneracy pressure.
But, in general, with enough mass, no force is needed, because the gravity does all the work itself. There is no energy expenditure with 3 solar masses of iron. There's a huge (enormous) gravitational force, but no energy.
With less mass, the force increases because a smaller Schwarzschild radius requires the Neutrons and quarks to get even closer, and the energy of such compression is enormous and hard to calculate.
Fortunately, there is a way to cheat and get a very simplified answer. The degenerate pressure that keeps the neutron star from becoming a black hole is in balance with the gravitational binding energy and gravitational binding energy can be estimated, assuming uniform density,
$$U=\frac{3GM^2}{5R}$$
(Source).
So, let's take a millionth of a gram of stuff, something heavy, like a piece of iron dust to avoid any fission energy that would work against black hole formation, and use our handy Hawking radiation calculator.
A one millionth of a gram black hole would have a radius of about $1.5 \times 10^{-36}$ meters (calculator above), so the gravitational binding energy, roughly equivalent to the neutron degeneracy pressure at Schwarzchild radius:
$$\frac{3 \times 6.67 \times 10^{-11} \times 10^{-9}}{5 \times 1.5 \times 10^{-36}} = 2.67 \times 10^{15}$$
or 26.7 million billion joules, crammed into a space smaller than an atom, just to make a 1 millionth of a gram black hole that should evaporate in a fraction of a fraction of a second. Now, there's probably a thousand reasons why my estimate is wrong, but it's ballpark (a very big, Texas-sized ballpark), but still in the ballpark.
Your estimate for CERN is that it uses 800 million watts. Now, remember, CERN accelerates beams of protons, thousands if not millions, and at current peak energy, each individual proton carries a maximum of about 13 trillion electron volts, and there are about $6.24 \times 10^{18}$ electron volts in a joule, so each individual CERN collision, proton onto proton has about 1/48,000 joules, at maximum power.
Now, even with my Texas-sized ballpark estimate, 1/48,000 is a much smaller number than 26.7 million billion. When the numbers are that far off, "bollocks" kinda covers it.
And a millionth of a gram black hole would evaporate anyway. It would be much smaller than an atom and would have a hard time absorbing much of anything. Not to mention the creation of such an object would probably have an initial velocity well above escape velocity and it would simply fly away from the earth (or right through it and away - like a heavy neutrino).
There's no estimate that creates a dangerous scenario using CERN's 1/48,000 joules per collision energy, and for an individual collision, that's enormous, but it's nowhere close to dangerous, unless you make the mistake of standing in the beam (that happened to somebody once, but...I digress). He lived by the way.
CERN can't put anywhere close to all 800 megawatts of energy into the acceleration of one proton. If they could, we might discover some very interesting things, but they can't even come close. All that energy powers the magnets and the vacuum and keeps everything cool, but the individual proton energy is a tiny fraction of that.
So, depending on what size black hole you want to create, CERN would need to be, oh, maybe a billion billion billion times more powerful than it currently is, and even so, the black hole created would probably evaporate before it ate anything, or, if Hawking radiation is wrong and it doesn't evaporate it would most likely fly harmlessly through the Earth, or, mostly harmlessly as it might do some harm if it flew through a person.
To create a black hole of low enough temperature to actually be stable, (and theoretically eat the Earth), you'd need, by the Hawking radiation calculator, millions of tons. And clearly we're deep into the impossible if you think CERN can crush millions of tons of iron into a speck the size of an atom. The orders of magnitude of improbability are higher than I can calculate.
Now, as to the flip side of this question and why it was thought that CERN might be able to create a black hole (so far they haven't), is because quantum black holes (theoretically) obey different rules over very short distances. They wouldn't last long and they wouldn't be dangerous. If quantum black holes can be created in CERN, then they are being created all the time by cosmic rays, on the surface of the moon, in the upper atmosphere of Earth. CERN does nothing that doesn't happen in the upper atmosphere all the time.
But to actually turn a speck of matter like a grain of sand into a black hole, the energy required would be billions and billions of times over what CERN is capable of. I can't give you an exact answer because I don't have the training in quantum calculations, and I'm not sure anyone can, or if they can, it will be very complicated.
In my opinion, "bollocks", covers it. But he could have said "yes, that could happen, if CERN were a billion billion billion billion times more powerful.
There's much easier ways to kill everyone on Earth than making a black hole that eats the Earth. In fact, that might be the hardest way to kill everyone ever thought up.
Hope you don't mind my narrative, but I think the gravitational binding energy approach isn't a bad way to answer your specific questions on energy required.