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.
From AWS Console in the Singapore region I am creating a mysql 8.x Multi-AZ instance. I want to make it a micro or medium but the only choices I see are large. How can I select medium or micro?...
Accepted AnswerMySQL
4
answers
0
votes
157
views
asked 7 months agolg...
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
267
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
414
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
1427
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
243
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
408
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
379
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
352
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
144
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
283
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
741
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
188
views
asked 7 months agolg...