MySQL/MariaDB: Revision history

January 7, 2025

• curprev 20:4320:43, January 7, 2025 J-Admin talk contribs 21,120 bytes −103 Cleaned up redundant "Change User Password (non-cPanel)" section

September 11, 2024

• curprev 12:4312:43, September 11, 2024 J-Admin talk contribs 21,223 bytes +702 →MySQL - keyring_file

April 23, 2024

• curprev 14:4314:43, April 23, 2024 J-Admin talk contribs 20,521 bytes +128 →Common commands/use: Added InnoDB status and showing storage engines
• curprev 14:3914:39, April 23, 2024 J-Admin talk contribs 20,393 bytes +566 Added section: "List tables of a particular storage engine"
• curprev 14:3314:33, April 23, 2024 J-Admin talk contribs 19,827 bytes +102 →Show size of databases: Added disclaimer about MariaDB 10.6 after re-testing this on a 10.6 VPS.
• curprev 14:3114:31, April 23, 2024 J-Admin talk contribs 19,725 bytes +318 →MyISAM table size & InnoDB table size: Updated to add Jack's total datadir one-liner

March 4, 2024

• curprev 18:5218:52, March 4, 2024 J-Admin talk contribs 19,407 bytes +1 →See all db users: Added line for legibility
• curprev 18:5218:52, March 4, 2024 J-Admin talk contribs 19,406 bytes +64 →See all db users: Added CLI instructions

November 10, 2022

• curprev 17:1517:15, November 10, 2022 J-Admin talk contribs m 19,342 bytes 0 →Show users that have grants on a specific database: Punctuation
• curprev 17:1517:15, November 10, 2022 J-Admin talk contribs 19,342 bytes +125 →Grants (Privileges): Added "Show users that have grants on a specific database"

October 21, 2022

• curprev 12:4812:48, October 21, 2022 J-Admin talk contribs 19,217 bytes +209 →Dumping: Added "Dumping the skeletons only"

October 3, 2022

• curprev 13:0013:00, October 3, 2022 J-Admin talk contribs 19,008 bytes +505 Added Mass Drop Users, switched around Show Compiled-in Options for organization

November 29, 2021

• curprev 17:2617:26, November 29, 2021 J-Admin talk contribs 18,503 bytes +407 →MariaDB - file_key_management: updated from waypoint
• curprev 16:5916:59, November 29, 2021 J-Admin talk contribs 18,096 bytes +70 →Prerequisites For Encryption: updating

October 6, 2021

• curprev 15:2415:24, October 6, 2021 J-Admin talk contribs 18,026 bytes +320 →Encrypting Database Tables At Rest: Added Manually Encrypt an InnoDB table
• curprev 15:0915:09, October 6, 2021 J-Admin talk contribs 17,706 bytes +265 →MariaDB - file_key_management: More options described
• curprev 14:5014:50, October 6, 2021 J-Admin talk contribs 17,441 bytes +121 →MariaDB - file_key_management
• curprev 14:4014:40, October 6, 2021 J-Admin talk contribs 17,320 bytes +515 →MariaDB - file_key_management: added some more options
• curprev 14:2214:22, October 6, 2021 J-Admin talk contribs 16,805 bytes +2,278 →MariaDB - file_key_management: Set basic info for file_key_management

September 23, 2021

• curprev 16:5216:52, September 23, 2021 J-Admin talk contribs 14,527 bytes +207 →Encrypting Database Tables At Rest: Partial setup instructions
• curprev 15:2515:25, September 23, 2021 J-Admin talk contribs 14,320 bytes +258 →Encrypting Database Tables At Rest
• curprev 15:2215:22, September 23, 2021 J-Admin talk contribs 14,062 bytes +272 →Restoring Encrypted InnoDB Tables From Raw Files
• curprev 15:2015:20, September 23, 2021 J-Admin talk contribs 13,790 bytes +750 →Encrypting Database Tables At Rest: Added restore section
• curprev 15:1015:10, September 23, 2021 J-Admin talk contribs 13,040 bytes +1,077 →Which Tables Are Currently Encrypted?: Added InnoDB and Aria examples
• curprev 15:0715:07, September 23, 2021 J-Admin talk contribs 11,963 bytes −10 →Prerequisites For Encryption
• curprev 15:0415:04, September 23, 2021 J-Admin talk contribs 11,973 bytes +18 →What Does & Doesn't Get Encrypted
• curprev 15:0415:04, September 23, 2021 J-Admin talk contribs 11,955 bytes +65 →Storage Engines
• curprev 14:4114:41, September 23, 2021 J-Admin talk contribs 11,890 bytes +515 →Encrypting Database Tables At Rest
• curprev 14:1014:10, September 23, 2021 J-Admin talk contribs 11,375 bytes +124 →Encrypting Database Tables At Rest
• curprev 14:0814:08, September 23, 2021 J-Admin talk contribs 11,251 bytes +199 →Encrypting Database Tables At Rest
• curprev 13:2913:29, September 23, 2021 J-Admin talk contribs 11,052 bytes +7 →What Does & Doesn't Get Encrypted
• curprev 13:2713:27, September 23, 2021 J-Admin talk contribs 11,045 bytes +937 →Encrypting Database Tables At Rest
• curprev 12:5912:59, September 23, 2021 J-Admin talk contribs 10,108 bytes +53 →Plugins
• curprev 12:5412:54, September 23, 2021 J-Admin talk contribs 10,055 bytes +1,183 Added Encrypting Database Tables At Rest section

January 22, 2021

• curprev 04:1704:17, January 22, 2021 J-Admin talk contribs 8,872 bytes −2 →cPanel: Even more formatting fun
• curprev 04:1704:17, January 22, 2021 J-Admin talk contribs 8,874 bytes +70 →cPanel: More formatting fun
• curprev 04:1604:16, January 22, 2021 J-Admin talk contribs 8,804 bytes +1 →cPanel: formatting
• curprev 04:1504:15, January 22, 2021 J-Admin talk contribs 8,803 bytes +1,645 Added Remote MySQL section
• curprev 04:0204:02, January 22, 2021 J-Admin talk contribs 7,158 bytes +1,593 Added secondary MySQL instance section
• curprev 03:5503:55, January 22, 2021 J-Admin talk contribs 5,565 bytes +20 Moved "InnoDB Disabled?" section to Troubleshooting
• curprev 03:5203:52, January 22, 2021 J-Admin talk contribs 5,545 bytes +104 Added Change User Password
• curprev 03:5003:50, January 22, 2021 J-Admin talk contribs 5,441 bytes +554 Added Grants
• curprev 03:2403:24, January 22, 2021 J-Admin talk contribs 4,887 bytes +3,008 Added dumping & importing, and InnoDB Disabled?
• curprev 02:3102:31, January 22, 2021 J-Admin talk contribs 1,879 bytes +1,879 Adding common commands