I'm pretty sure that it is legally enforceable in most jurisdictions, B2B contracts are almost always stronger/more binding than consumer ones (since that protections granted under consumer protection laws are gone, and there is a reasonable presumption that the parties have read and understand the contract). The blurrier part is for sole proprietorships, since it depends on whether their specific jurisdiction considers them as consumers under consumer protection laws (which uniformly weakens contracts to the extent that it does not comply with the guarantees for consumers).
(Note that in most jurisdictions, most "copyright licenses" are considered as contracts. For example, multiple cases in French courts have resolved that GPL2 is considered a contract.)
Also, the license text: https://mariadb.com/bsl11/
I don't think accepting a contract can qualify as consideration for that contract, as otherwise there would never be a need for consideration in any contract.
> Promissory estoppel/detrimental reliance: A contract without consideration is enforceable if the nonperformance of the promisor will cause injustice. Elements of promissory estoppel are (i) the promise has reasonable, foreseeable, and detrimental reliance on the promisor, and (ii) the enforcement of the promise is necessary to avoid injustice.
In this case, you are nearly correct that the performance to honor the terms of the contract is essential, but technically not a consideration. (The IP code is consideration though.)
Restrictive covenants on open source licenses might not be consideration, particularly because they apply to the IP licensed in the contract - something that the user/downloader of the software wouldn't have without the contract. In other words, you are giving them rights to use your IP in a few specific ways in exchange for nothing. They need to give up something of value that they wouldn't have otherwise had for it to undeniably be consideration.
Again (https://news.ycombinator.com/item?id=33587891), this is a misconception. Unless there's something in the contract that is outright illegal, mutual consideration automatically binds parties into the contract, but the absence of it does not automatically voids the contract (see one-way NDAs between companies and promissory notes). Worse, you've confused consideration with a monetary value. Consideration don't need to be a monetary value: often, it's performance. This can get confusing because often contracts have a monetary consideration for a performance consideration (for example, paying for mowing the loan), but in this case it has been inverted: for not using it commercially (performance consideration) you can use the IP (monetary consideration).
Courts haven't yet determined which construction is correct.
Edit: I will also add that I said "of value" not "of monetary value." Lots of things with value don't have well-defined monetary value.
In the absence of an enforceable license isn't the default no rights, not all rights? So why would a user make that argument?
They might have an argument against you if the software is at all part of your value chain.