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.
My customer is using AWS EMR and is storing all the Hive meta data on an external RDS instance, using MySQL 5.7.* And since MySQL 5.7 is running out of its lifecycle, we are pushing them to upgrade...
1
answers
1
votes
279
views
asked 6 months agolg...
I am connected to MySQL RDS instance of our database with super admin privileges. When I execute the following statements below it results in error
Error Code: 1227. Access denied; you need (at least...
1
answers
0
votes
443
views
asked 6 months agolg...
SSH was corrupted in my Lightsail instance.
I have created a manual snapshot from my instance.
Using this snapshot I have created another instance.
I was able to reach this instance using SSH.
This...
5
answers
0
votes
220
views
asked 6 months agolg...
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
147
views
asked 6 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
260
views
asked 6 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
385
views
asked 6 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
1261
views
asked 6 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
233
views
asked 6 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
383
views
asked 6 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
330
views
asked 6 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
317
views
asked 6 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
136
views
asked 6 months agolg...