How To Use SSL With sysbench To Test MySQL Server

Author: , September 7th, 2023

SUMMARY If sysbench is started with the “–mysql-ssl=on” option, it looks in the current directory for the following files:

PROCEDURE Locate the current MySQL database certificates, usually in /var/lib/mysql, and make sure that the OS user running sysbench is able to read the following 3 files:

Next, cd to the OS user’s home […]

How To Upgrade MySQL to 8.0 on CentOS/AWS Linux

Author: , August 31st, 2023

START: Server version: 5.7.43-log MySQL Community Server (GPL) FINISH: Server version: 8.0.34-log MySQL Community Server (GPL)

https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html Check and veify your my.cnf ssl entries if you see the following error in the /var/log/mysqld.log file at startup:

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