Ferreteria/v0.6/clade/Sys/Data/Engine/Oper/MyMar/Maria

From Woozle Writes Code
< Ferreteria‎ | v0.6‎ | clade‎ | Sys‎ | Data‎ | Engine‎ | Oper‎ | MyMar
Jump to navigation Jump to search
clade: Sys\Data\Engine\Oper\MyMar\Maria
Clade Family
MyMar Maria (none)
Clade Aliases
Alias Clade
Base* [ca,i] Sys\Data\Engine\Oper\MyMar
Subpages

About

  • Purpose: any helpful specifics that work best with MariaDB in particular

History

  • 2024-11-19 cannibalizing old MySQL stuff
  • 2024-12-03 removing `DefaultPort()`, on the theory that the remote server might be configured to use specific ports by default, and the user shouldn't have to update their local configuration updated to match that.
  • 2025-04-11 Changed `OpenTunnel()`/`ShutTunnel()` -> `Open()`/`Shut()`. Not sure if this will work if DBC is non-local; to be tested.
  • 2025-05-30 Restructuring:
    • Moved from [WFe]Sys\Data\Engine ⇒ [WFe]Sys\Data\Engine\Ops\MyMar
    • extracting Connection bits to Conn classes as appropriate
    • extracting bits that are common to MySQL into MyMar parent clade

Details

To create root user:

  • for MySQL >= 5.7.6, MariaDB >= 10.1.20:
    • ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
      • CREATE USER 'root'@[...] does not seem to work. (Maybe the root user already exists, usually?)
  • for earlier versions:
    • SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');

Code

interface iMaria extends BaseIface {}
class cMaria extends BaseClass implements iMaria {}