All Questions
52
questions
0
votes
3
answers
348
views
Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2
I am working with EC2 for MySQL DB. The OS of EC2 is AWS Linux-based Ubuntu. The current version of MySQL is 5.6.50. I am going to upgrade it to 8.0. I tried to upgrade it with this command: sudo yum ...
- 51
0
votes
1
answer
827
views
How to choose right AWS EC2 instance for serving MySQL
Recently we have noticed that our application has some errors related to the MySQL load.
There are some basic queries on large database (approximately 32 GB) which takes longer time than expected.
For ...
- 101
7
votes
3
answers
4k
views
AWS RDS MySQL Slowing down over time
I've read many posts about this topic but none of them talk about AWS RDS MySQL Database. Since three days ago, I'm running a python script in an AWS EC2 instance that write rows in my AWS RDS MySQL ...
- 75
1
vote
1
answer
219
views
Automate EC2 and RDS mysql service to reset mysql db
I have a CRM application (java + Gradle) in Running in AWS Ec2, backend with RDS Mysql database. This is a test app/Environment.
Scenario :
CRM app should be stopped.
Reset RDS MYSQL database weekly ...
1
vote
1
answer
2k
views
How could I connect MySQL Server (on a EC2 ) from another EC2?
I create two instances on EC2 (CentOS 7). I am trying to deploy MySQL InnoDB Cluster. When I add instance (slave) I found master cannot be connected.
I can use GUI tool on my local to connect the ...
- 123
-1
votes
1
answer
172
views
can't connect mysql server on windows server from home computer
I install MySQL Server on a Windows Server from Amazon EC2 with all default config (port 3306 is open).
I edited Security Group on AWS to open port 3306 like this
But every time i try to connect ...
0
votes
2
answers
3k
views
cannot connect to aws rds mysql from aws ec2 instance via web browser
I have set up an AWS RDS instance and AWS EC2 instance, and I believe I set up the security group to allow both EC2 instance's internal ip and public ip to access the RDS instance. if I ssh to EC2 ...
3
votes
2
answers
12k
views
Connecting to an RDS from an EC2 on the same VPC
I have an RDS instance running on one subnet without NAT, and an EC2 instance running on another subnet with an Internet Gateway configured, both located in the same VPC. I have configured the RDS ...
- 133
2
votes
1
answer
945
views
Setting up phpmyadmin to only connect to remote server
I've been stuck on this for a while, and was hoping you could provide some insight into what I'm doing wrong.
I have a fresh amazon EC2 (Ubuntu 16.04) instance connected to an RDS (mysql) database, ...
18
votes
5
answers
17k
views
Install of MySQL hangs on Ubuntu 16.04
I’m trying to install MySQL server on Ubuntu 16.04 using:
sudo apt-get install mysql-server
I get asked to set and confirm root password and then the install hangs at:
Renaming removed key_buffer ...
- 385
1
vote
2
answers
22k
views
How to set root password for aws ec2 with mysql preinstalled?
I have an EC2 instance with mysql preinstalled.
I need to now use mysql - therefore I need a root password, however when I try and run:
mysqladmin -u root password [aBc123DeF]
I get the following ...
- 145
2
votes
1
answer
7k
views
install mysql 5.7 to linux 6 - yum tries to install 5.7 el7?
I'm following the instructions here to install MySQL-Community-Server onto a linux 6 aws instance.
Basic commands:
wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm
sudo yum ...
- 231
2
votes
2
answers
5k
views
PHP and MYSQL on Amazon EC2 server
I am trying to set up an amazon server to display my php files for a final for one of my classes. I followed this tutorial for setting it up and when I try to run my code I get "Fatal error: Class '...
- 21
0
votes
2
answers
2k
views
Using MySQL with Ejabberd
I'm trying to integrate MySQL into Ejabberd but I'm constantly facing problem with it. I'm working in AWS EC2 environment and I have 1 EC2 instance that has MySQL, Ejabberd and latest Erlang (Version ...
- 101
3
votes
2
answers
6k
views
Amazon RDS instance and hostname resolution
I have a question about EC2 and RDS instances.
I'd like to restrict connection to the database only from one particular EC2 instance using MySQL users.
Security groups allow MySQL communication from ...
- 43