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
Databases
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 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
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: <span class="kwd" style="font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; box-sizing: inherit; color: #101094;">ALTER</span> <span class="kwd" style="font-style:
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
Could not create the upgrade info file ‘/var/lib/mysql/mysql_upgrade_info’ in the MariaDB Servers datadir, errno: 13
Whilst doing this: mysql_upgrade -uusername -ppassword You get this: Could not create the upgrade info file ‘/var/lib/mysql/mysql_upgrade_info’ in the MariaDB Servers datadir, errno: 13 Solution:
How to rename a MySQL database
Apparently long ago there was a rename database command but this was dropped for security reasons. Now you have to do this: for table in