Prerequisites Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands. Audience Cloud Administrators Database Administrators Database Designers Web Administrators Topics Install and configure MySQL Server on AWS EC2 Installation of MySQL 5.7 25 minutes Upgrade MySQL on Running servers Tips to Upgrade and what you should know before upgrade …
Author: Mikael HOUNDEGNON GBAI
Should i run MySQL server on Windows or linux
Running MySQL on a Windows server is not necessarily "not recommended," but there are several factors that might make it less ideal compared to running it on a Linux server in certain scenarios. Here are a few reasons: Performance: Historically, MySQL has been optimized for Linux/Unix environments, which may result in better performance compared to …
Continue reading Should i run MySQL server on Windows or linux
How to find unregistered user trying to login in MySQL
Unregistered user that is trying to login to MySQL can generate below error is MySQL error log 2023-10-25T15:13:38.913862Z 1716 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' as you can see none of my user is using sha256_password mysql> select user, host …
Continue reading How to find unregistered user trying to login in MySQL
Dolphie new open source monitoring tools for MySQL DBAs
Welcome to Dolphie, new open source CLI monitoring tool for MySQL DBAs. It's an alternative to innotop and very easy to use, more details on the #github repo https://lnkd.in/gyFVHxrx Installation Requires Python 3.8+ Using PyPi $ pip install dolphie Using Poetry $ curl -sSL https://install.python-poetry.org | python3 - $ poetry install Using Homebrew If you …
Continue reading Dolphie new open source monitoring tools for MySQL DBAs
MySQL Server 8.0.33 Crash when FIPS is enabled only on OS side
FIPS is Federal Information Processing Standards 140-2 (FIPS 140-2) describes a security standard that can be required by Federal (US Government) agencies for cryptographic modules used to protect sensitive or valuable information. When FIPS is enabled on the Operating System and not enabled in MySQL it crashed with the following error 2023-07-24T14:32:44.925574Z 4 [System] [MY-013381] …
Continue reading MySQL Server 8.0.33 Crash when FIPS is enabled only on OS side
Fix MySQL Async replication Error 1236 within GTID Replication
This error is related to the Replication IO_Thread being stopped with Error Number 1236. The error Message 1236 can be triggered by many reason i will try my best to cover the most common reasons. Please keep in mind i'm using GTID replication, in case you're using Binary log file/position replication some solution to fix …
Continue reading Fix MySQL Async replication Error 1236 within GTID Replication
How to connect to MySQL using a client certificate
Reposting Frederic Descamps article about MySQL SSL Connection using self certificate https://blogs.oracle.com/mysql/post/howto-connect-to-mysql-using-a-client-certificate
MySQL Auto Increment Percentage Used
When you're keeping historical data from day one in your MySQL table with a signed or unsigned integer on a highly transactional environments, you can ended up reaching the max value for your auto increment column data type, use this guide to find out what is the min and max auto increment value for each …
Troubleshoot MySQL/LDAP Auth_pam error when apparmor is enforced
First let setup MySQL to use auth_pam authentication and trigger the issue we want to troubleshoot Check if PAM authentication is setup root@db-test3:/usr/lib64/mysql/plugin# cat /etc/pam.d/mysql #%PAM-1.0 auth required pam_sss.so account required pam_sss.so Create a user with auth_pam plugin mysql> INSTALL PLUGIN auth_pam SONAME 'auth_pam.so'; mysql> CREATE USER mgbai@'127.0.0.1' IDENTIFIED WITH auth_pam AS 'mysql'; mysql> GRANT …
Continue reading Troubleshoot MySQL/LDAP Auth_pam error when apparmor is enforced
How to fix Fatal error: mysql.user table is damaged. Please run mysql_upgrade.
If your error message is similar to the following in your mysql error log you can use the following tips to fix it 2022-06-21T12:44:27.206605Z 0 [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade. 2022-06-21T12:44:27.206633Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2022-06-21T12:44:27.206671Z 0 …
Continue reading How to fix Fatal error: mysql.user table is damaged. Please run mysql_upgrade.