How to reset / recover a MySQL root password
Update February 2022 Resetting MySQL password remains a nightmare due to all the differences between MySQL 7 and 8, and MariaDB. If you’re running the
Databases
How do you rename a MySQL table?
rename table t1 to t2; Reference: https://blog.marceloaltmann.com/en-how-to-rename-table-in-mysql-pt-como-renomear-tabelas-no-mysql/
How to cluster / set up MySQL for redundancy
MySQL has two good methods for replication, the one called Master-Master Replication, and the other called Group Replication. Group replication is more powerful and is
Help! I’m getting access denied trying to access a remote / local MySQL database
Sometimes when you try to access MySQL, you will get an access denied message. There could be a multitude of reasons but if you are
What literals exist for time series when you’re using InfluxDB?
u or µ microseconds ms milliseconds s seconds m minutes h hours d days w weeks Reference: https://docs.influxdata.com/influxdb/v1.7/query_language/data_exploration/#duration-literal
How to upgrade MariaDB from 10.1 to 10.3 Ubuntu Bionic (18.04) LTS Server
Background This article explains how to upgrade the default MariaDB 10.1 installation provided with Linux Mint 19 Tara or Tessa to MariaDB 10.3. One reason
How do you alter a MySQL table to make a column nullable?
Do this: ALTER TABLE mytable MODIFY mycolumn VARCHAR(255); Ps. You have to know what the original type is. Reference: https://stackoverflow.com/questions/212939/how-do-i-modify-a-mysql-column-to-allow-null
How to backup a MySQL database using the command line
The syntax is straightforward: mysqldump -uusername -ppassword database_name > db.backup.date
Backups Failing: …tables used by Event Scheduler were found damaged at server start (1577)
On your MySQL Server doing backups you get: Backups Failing: Dumping MySQL database database_name …. dump failed! mysqldump: Couldn’t execute ‘show events’: Cannot proceed because
Communication link failure: 1153 Got a packet bigger than ‘max_allowed_packet’ bytes (SQL: update…
Whilst updating a Trix Editor field box with many images, you get the following error: [2019-01-18 10:12:07] local.ERROR: SQLSTATE[08S01]: Communication link failure: 1153 Got a