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.
We have a MySQL multi-AZ instance on t2 class, which needs to be migrated to t3 family.
AWS documentation says this requires downtime, which is understandable. But it also mentions that only one...
Accepted AnswerMySQL
1
answers
0
votes
26
views
asked a day agolg...
I'm trying to remove a database but i'm getting this error:
SQL Error [1010] [HY000]: Error dropping database (can't rmdir './databasename', errno: 39)
I've been reading solutions, but it looks like...
1
answers
0
votes
74
views
asked 2 days agolg...
We recently upgraded MySQL 5.7 to MySQL 8.0.35 and are noticing huge performance problems in our production website.
Any insights as to what sort of queries can cause performance issues? Any config...
Accepted AnswerMySQL
1
answers
0
votes
46
views
asked 2 days agolg...
I hope someone has some ideas on how to resolve the following issue I'm facing.
Here's the setup:
- 8.0.mysql_aurora.3.06.0 cluster with a writer and a reader instance(db.r7g.large)
- PHP web...
0
answers
0
votes
55
views
asked 4 days agolg...
Trying to connect MySQL RDS through VM machine by using mysql connectionstring. RDS is in private subnet and public accessible also set to false. Private Subnet routetable is mapped with Nat...
2
answers
0
votes
125
views
asked 5 days agolg...
2) MySQL 8.0 syntax check for routine-like objects
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
More Information:
https://dev.mysql.com/doc/refman/en/keywords.html
mysql.flush_rewrite_rules -...
0
answers
0
votes
56
views
asked 11 days agolg...
We have a snapshot of RDS version 8.0.33 and we want to migrate to any potential version of Aurora MySQL.
The problem is that on the migration screen there are Aurora MySQL 3.05.2 and 3.06.00 which...
2
answers
0
votes
264
views
asked 12 days agolg...
Hello,
My RDS won't connect to MySQL Workbench or Power BI.
* MySQL Workbench error: "Failed to connect to MySQL at [endpoint URL] with user [username]. Unable to connect to localhost".
* Power BI...
2
answers
0
votes
224
views
asked 14 days agolg...
l have created a test mysql database but l am failing to connect using mysql navicat. l am getting this error.
2002 - Can't connect to server on...
1
answers
0
votes
179
views
asked 14 days agolg...
Good day, on April the 29th AWS did a forced upgrade to our MySQL on RDS istance to version 8.0.31 from an older one we had.
Immediatelly after and without any modification our APP installed on a EC2...
Accepted AnswerMySQL
2
answers
0
votes
80
views
asked 15 days agolg...
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...
7
answers
3
votes
691
views
asked 16 days agolg...
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...
1
answers
0
votes
126
views
asked 16 days agolg...