How To Reset The MySQL 5.5 Server root Password

Author: , March 16th, 2022

Had an old server, needed to get root.

For MySQL 5.7: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html For some other v5.7 nodes, I had admin access via a different user’s login, so all I needed was this:

How To Solve MySQL GPG Key Errors During yum update

Author: , February 19th, 2022

I went to perform a yum update and got the following error:

SOLUTION: Import the needed new key and manually edit the config files before retrying the yum update.

I had to edit two files: mysql-community-source.repo and mysql-community.repo

For 5.7 – add -2022 to the key name: i.e.: ORIGINAL:

MODIFY ONE […]

How To Control Output Formatting Via The MySQL Shell CLI

Author: , May 26th, 2021

-N: No column headers -B: Batch mode – use tabs as field separators https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-output-formats.html Multiple Formats Available: Table Format – use –result-format=table, alias –table Tab Separated Format – use –result-format=tabbed, alias –tabbed Vertical Format – use –result-format=vertical, alias –vertical JSON Format Output – use –result-format=VALUE, alias –json[=pretty|raw|off] VALUE may be one of: json or […]

How To Determine Where MySQL Looks For my.cnf

Author: , March 22nd, 2021

Ah, the power of grep!

How To Install MySQL 8.0 on AWS Linux 2

Author: , November 18th, 2020

How To Install MySQL on MacOS Using Brew

Author: , April 5th, 2020

As a non-root user:

Make sure your PATH contains /usr/local/bin

How To DROP DATABASE LIKE In MySQL

Author: , January 21st, 2020

Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves

Author: , September 26th, 2019

Make It Faster: Improving MySQL Write Performance for Tungsten Cluster Slaves

10 Reasons Why Tungsten Clustering Beats the DIY Approach for Geo-Distributed MySQL Deployments

Author: , August 29th, 2019

Why does the DIY approach fail to deliver vs. the Tungsten Clustering solution for geo-distributed MySQL multimaster deployments? Before we dive into the 10 reasons, note why commercially-supported enterprise software is less risky and in fact less costly.

Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance

Author: , August 26th, 2019

Zero-Downtime Cluster Maintenance: Comparing the Procedures for Upgrades versus DB/OS Maintenance