If you plan for example to have a bastion host in the cloud to access all your MySQL servers and use only MySQL Shell, the first time you connect to one of the host, you will realize that MySQL Shell prompts for a password but doesn’t ask you to store it of not. Example: mysqlsh fred@192.168.5.94 Please provide the password … Read More
I wanted to be brave and I installed MySQL Group Replication manually…. it was painful ! Then I realized that managing those servers and especially deal with MySQL Routers was even more painful ! What are my options now ? Is there a solution or do I need to restart from scratch ? Asking the answer is already answering it… … Read More
This morning, a user asked in the MySQL Community Slack if somebody had an idea why the error log was filled up continuously with a warning messages like this one: 2020-07-24T06:54:00.877128Z 46 [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’ The context was that the user upgraded … Read More
In MySQL, it’s very common and recommended to you an auto_increment as Primary Key. However that integer can have different types each having their size limitation, and they can also be signed or not. Many people when creating a table use by default the following syntax do define their auto_increment primary key: id int auto_increment primary key This is a … Read More
In MySQL 8.0.21, we can see who and how mysqld was stopped and when the process ended. Let’s have a look at different scenarios in this article. SHUTDOWN SQL statement The first test is to initiate the shutdown of MySQL from a SQL client: mysql> shutdown; In the error log (log_error_verbosity is set to 2, the default), we can see: … Read More
comments