Questions tagged with MySQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Before updating to 8.0 I can easily create a Table on Mysql management studio. But now if I try to create a table it always gives me an
"Error Code: 1044. Access denied for user 'admin'@'%' to...
0
answers
0
votes
266
views
asked 7 months agolg...
import pymysql
# Database connection parameters
endpoint = 'my-endpoint' # your RDS endpoint
username = 'admin' # your RDS username
password = 'my-password # your RDS password
# Establish a...
1
answers
0
votes
412
views
asked 7 months agolg...
I want to change my reader instance to one that can write and delete the existing writer instance.lg...
Currently, I am using MySql and DB synchronous replication with two instances of reader and writer (both are already standalone instances.). But I would like to remove the writer instance and set the...
2
answers
0
votes
1396
views
asked 7 months agolg...
I am using RDS for mysql, t3.micro with 200GB storage (gp2)
I enabled MARIADB_AUDIT_PLUGIN in my option group.
It works well but my readthroughput went too high(**UP to 100MB/seconds **) that my...
1
answers
0
votes
241
views
asked 7 months agolg...
Currently, I am using mysql in rds with two instances of reader and writer, but I would like to remove the writer instance and set the reader instance to read/write.
This is an attempt to reduce...
1
answers
0
votes
402
views
asked 7 months agolg...
My organization has received a notification from AWS indicating that we need to update our TLS certificates for our RDS's by.... well, next August.
I've looked over the documentation in the email,...
1
answers
0
votes
369
views
asked 7 months agolg...
There is no example in documentation how to define Extra connection attributes for target endpoint in case you have more than one settings. I have to set for MySQL:
SET FOREIGN_KEY_CHECKS=0 and SET...
1
answers
0
votes
343
views
asked 7 months agolg...
Hello,
I have a question regarding a root access in my sql database from aws.
I have a lightsail and also instance of mysql database. I need to get root access , I can only see dbmasteruser .
1
answers
0
votes
142
views
asked 7 months agolg...
I have a source DB MySQL v5.6 community edition as a source DB and AWS RDS MySQL v5.7 as target in AWS DMS and have an issue with time field type. DMS task is full load and replication. During full...
3
answers
1
votes
282
views
asked 7 months agolg...
Hi Team,
I have an MSSQL database on Microsoft Azure, and I'm planning to migrate single table data from MSSQL Server to an AWS EC2 instance running MySQL. However, when I execute the migration...
1
answers
0
votes
740
views
asked 7 months agolg...
We 've a requirement to rotate the secrets for RDS MySQL. we are following the steps mentioned in the documentation...
1
answers
0
votes
185
views
asked 7 months agolg...
Hi Team,
I have an MSSQL database on Microsoft Azure, and I'm planning to migrate data from one table to an AWS EC2 instance running MySQL. However, when I execute the migration task, I encounter the...
1
answers
0
votes
1210
views
asked 7 months agolg...