It seems you are trying to write special characters to some of the sensors which cause issues with certain DB back ends. See below.
Perhaps this works ok on SQLLite back end? Surprised someone else hasn’t found this already as Mysql is pretty common.
2019-03-25 17:18:56 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (_mysql_exceptions.OperationalError) (1366, "Incorrect string value: '\\xE2\\x97\\x8FOld...' for column `homeassistant`.`states`.`state` at row 1") [SQL: 'INSERT INTO states (domain, entity_id, state, attributes, event_id, last_changed, last_updated, created, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: ('sensor', 'sensor.connorsmacbookpro_info', '●Old Location, #65, Age 65.4m', '{"icon": "mdi:information-outline"}', 1269081, datetime.datetime(2019, 3, 25, 19, 39, 15, 539267, tzinfo=<UTC>), datetime.datetime(2019, 3, 25, 19, 39, 15, 539267, tzinfo=<UTC>), datetime.datetime(2019, 3, 25, 21, 18, 56, 93425), '097138f0d49c4622bdaf90d000de3143', None)] (Background on this error at: http://sqlalche.me/e/e3q8)
2019-03-25 17:18:56 ERROR (Recorder) [homeassistant.components.recorder] Error in database connectivity: (_mysql_exceptions.OperationalError) (1366, "Incorrect string value: '\\xE2\\x97\\x8FOld...' for column `homeassistant`.`states`.`state` at row 1") [SQL: 'INSERT INTO states (domain, entity_id, state, attributes, event_id, last_changed, last_updated, created, context_id, context_user_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: ('sensor', 'sensor.connorsmacbookpro_info', '●Old Location, #65, Age 65.4m', '{"icon": "mdi:information-outline"}', 1269081, datetime.datetime(2019, 3, 25, 19, 39, 15, 539267, tzinfo=<UTC>), datetime.datetime(2019, 3, 25, 19, 39, 15, 539267, tzinfo=<UTC>), datetime.datetime(2019, 3, 25, 21, 18, 56, 93425), '097138f0d49c4622bdaf90d000de3143', None)] (Background on this error at: http://sqlalche.me/e/e3q8). (retrying in 3 seconds)