Questions tagged with MySQL

I'm using AWS RDS, and in my MYSQL (>8.0) database, the SYSTEM_VARIABLES_ADMIN permission for all users is deleted every 10 minutes. It wasn't deleted originally, but it's suddenly being deleted, and...

I am trying to upgrade MySQL from 5.7.44 to 8.0.28 and I end up needing to remove a stored procedure named `mysql.flush_rewrite_rules` but I have no permissions to do so. Therefor I am blocked and...

I'm trying to upgrade the mysql instance from 5.7.44 to 8 and up. I have a smaller scale "test" db with the same configuration as my production db. Last week I tried and managed to get the test side...

Hi, We are considering a replication setup where we would like to replicate only a few tables from an "external" MySQL instance (replication source - hosted in EC2) to Aurora MySQL (replication...

Hi, I have a Maria DB (Instance class: db.r4.large, Engine version 10.4.32) that I need to update to a R5 engine. I want to use a Blue/Green deployment to achieve this but I am getting errors when I...

I need to transfer data from one test Aurora mysql instance to another. And don't want to set up DMS for such a small task. But any option (single-transaction etc) I give to mysqldump command, i get...

Currently investigating the work required on our part to prepare for updating the certificate on our RDS MySQL instances, and was wondering if I shutdown our existing rds-ca-2019 dev/test instances -...

Hello, I am attempting to install mysql on SUSE linux instance. When attempting to start mysql server, the system requires a root password I am logged in as the ec2-user as it is the default. How can...

I'm part of an NGO & we are building a website that uses MySQL as the database. Since we don't have a DBA on the team, we were considering using AWS RDS. I was looking at the 4vCPU with 16Gig option...

Hi, we have a system developed in python, the system is for answer questions about pdf legal text files using chatgpt api, works like this: User logins (mysql for validate and store user data), then...

My application is hosted in Ec2 instance(windows) and MySQL database in AWS RDS. Since both Ec2 instance(windows) and RDS MySQL both are in same vpc same region and on private subnet, my application...

I am checking my databases, I have 2 with Mysql Aurora and one with Mysql Community. In one of the Aurora databases, the activity is measured in “Sessions”. According to the definition in the...