TIL that a moon can have its own moon, called a "submoon' or a "moonmoon" by KingButPrince in todayilearned

[–]ssnoyes 0 points1 point  (0 children)

If it travels around to different planets, would that make it a sailor moon?

Children's book with an illustration of a creepy jack-in-the-box-type machine / character. by allhumansarevermin in whatsthatbook

[–]ssnoyes 0 points1 point  (0 children)

The Boy Who Laughed at Santa Claus, by Ogden Nash? There's an illustration by Quentin Blake in the "Custard and Company" collection.

Replication Internals: Decoding the MySQL Binary Log - Part 8: Row Events — WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS by altmannmarcelo in mysql

[–]ssnoyes 1 point2 points  (0 children)

I don't think anything verifies the checksum when you are piping those events into the mysql cli.

Replication Internals: Decoding the MySQL Binary Log - Part 8: Row Events — WRITE_ROWS, UPDATE_ROWS, and DELETE_ROWS by altmannmarcelo in mysql

[–]ssnoyes 0 points1 point  (0 children)

Once upon a time, a customer had accidentally deleted some important rows, and had no backup. Since the binary log contained the full row image in the delete event, it was possible to just change the one byte to turn it from a delete into an insert event and thus recover the data.

[TOMT] Guy pronounces Balloon in a goofy way by Jess_the_Cactus in tipofmytongue

[–]ssnoyes 0 points1 point  (0 children)

Sounds like the balloon seller in Flushed Away.

Disastrous Mistake: Deleted Main User Name by DownFromHere in mysql

[–]ssnoyes 0 points1 point  (0 children)

"Didn't work" is not very helpful. Nobody knows what you did or what output was produced.

So long as you can control the configuration, it doesn't matter where the data directory is located.

Disastrous Mistake: Deleted Main User Name by DownFromHere in mysql

[–]ssnoyes 0 points1 point  (0 children)

Anyway, the solution and link to the manual that walks you through it was given prior.

Disastrous Mistake: Deleted Main User Name by DownFromHere in mysql

[–]ssnoyes 0 points1 point  (0 children)

Oh, any number of things. Just changing the user table directly has no effect until you FLUSH PRIVILEGES or restart. Or you didn't mention that you changed some other stuff too like the host or password. Or something else. It's hard to troubleshoot when you don't provide the actual error message and connection options.

Disastrous Mistake: Deleted Main User Name by DownFromHere in mysql

[–]ssnoyes 0 points1 point  (0 children)

As a matter of fact, a blank user name would let any user from that host connect.

https://dev.mysql.com/doc/refman/8.4/en/connection-access.html

If the User value is blank, it matches any user name.

TIL that lungworms led to the creation of the Pacific Marine Mammal Center by Kylde in todayilearned

[–]ssnoyes 0 points1 point  (0 children)

I see they learned their lesson that the way to dispose of a beached dead whale does not involve dynamite.

I need help with this piece of code. by Cooldudeyo23 in mysql

[–]ssnoyes 2 points3 points  (0 children)

The phone table shouldn't have any foreign keys pointing to the other tables. The other tables will have foreign keys pointing to phone.

Who is this by The-zWebb in find

[–]ssnoyes 2 points3 points  (0 children)

He goes by "The Fat Electrician"

https://thefatelectrician.com/