trendoceans

How do I Turn Off or Remove the MySQL Password Validation

Have you set the Password Validation setting to “Strong, Medium, or Low”? Read the steps to update the password policy in MySQL. While working on my local environment, I have set the password ...
GitHub

Install the MySQL client and/or server.

Meta-state that includes all server packages in the correct order. This meta-state does not include mysql.remove_test_database; see below for details. If no root password is provided in the pillar, a ...
Ars Technica

[MySQL] Remove a column's DEFAULT value?

I'm trying to remove the DEFAULT value from some mediumint and int columns in a MyISAM table.<BR><BR><pre class="ip-ubbcode-code-pre">ALTER TABLE `table_name` ALTER ...
LinkedIn

Safely remove MySQL binlogs in a master-slave setup

Have you ever had the issue of MySQL binlogs filling up your disk on the Master server, but don't want to automatically remove by X days, or Y number of files in case there has been a problem with the ...
LinkedIn

Remove invalid utf8mb3 characters on MySQL

If tables or columns comment that include an invalid utf8mb3 character, you might experience [ERROR] [MY-013140] when you perform a major version upgrade on MySQL. You can refer my article to remove ...