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
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
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
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 …
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.
Sometimes when Oracle MySQL is already installed and you want to install percona xtrabackup after you can have the following conflict yum install percona-xtrabackup Transaction check error: file /etc/my.cnf from install of Percona-Server-shared-56-5.6.30-rel76.3.el7.x86_64 conflicts with file from package mysql-community-server-5.7.13-1.el7.x86_64 Below 3 steps will help you to resolve the issue : 1) Download mysql-community-libs-compat from …
Continue reading Fix Percona Xtrabackup Installation conflicts with mysql-community-server
Following is just handy commands to manage a passwordless authentication to MySQL using mysql_config_editor. This utility enables you to store authentication credentials in an obfuscated login path file named .mylogin.cnf. The file location is the %APPDATA%\MySQL directory on Windows and the current user's home directory on non-Windows systems. Add a login path mysql_config_editor set --login-path=proxysql --host=127.0.0.1 --port=6032 --socket=/tmp/proxysql.sock …
Continue reading create MySQL Passwordless authentication using login-path
Here is my favorite handy query Tables Without Primary Key USE INFORMATION_SCHEMA; SELECT TABLES.table_schema, TABLES.table_name FROM TABLES LEFT JOIN KEY_COLUMN_USAGE AS c ON ( TABLES.TABLE_NAME = c.TABLE_NAME AND c.CONSTRAINT_SCHEMA = TABLES.TABLE_SCHEMA AND c.constraint_name = 'PRIMARY') WHERE TABLES.table_schema not in ('information_schema','performance_schema','mysql') AND TABLES.table_type = 'BASE TABLE' AND c.constraint_name IS NULL;
Have you tried connecting to your MySQL server only to get the annoying error, "too many connections" ? This means that the number of available connections are in use by other clients on the server. And it can be quite annoying to get this error especially when you have an urgent need to access your …
Continue reading What you should know before changing MySQL max_connections variable
MySQL updatable/Insertable views Introduction to MySQL updatable views In MySQL, views are not only query-able but also updatable. It means that you can use the INSERTor UPDATE statement to insert or update rows of the base table through the updatable view. In addition, you can use DELETE statement to remove rows of the underlying table through the view. However, to create an updatable view, the SELECT …
Mikael HOUNDEGNON MySQL Wall 