All Questions
Tagged with amazon-ec2 mysql
990 questions
0
votes
1
answer
25
views
Troubles when connecting with RDS MySQL instance from MySQL workbench
I created this MySQL RDS instance:
With the Connectivity & security section looking like this:
The following inbound rules:
And this routes config:
When I test the connection from MySQL ...
- 35
-1
votes
1
answer
28
views
Can't connect to my MySQL container from another container all running in the same EC2 instance [closed]
I am running docker on an EC2 instance. One container is MySQL 8.0 and the other is running a Spring Boot app. On my local Mac machine, when I start both containers, the Spring Boot app is able to ...
- 2,149
0
votes
1
answer
44
views
Can't connect to Amazon RDS MySQL instance (Error 2003 HY000 - Can't connect to MySQL server)
I'm trying to connect to my Amazon RDS MySQL instance from my local machine using MySQL Workbench and the MySQL CLI, but I keep getting the following error:
ERROR 2003 (HY000): Can't connect to MySQL ...
- 143
0
votes
1
answer
36
views
MySQL Copy Column From Table to other Table [duplicate]
i have 3 tables:
ec2
id_resource
name_resource
rds
id_resource
name_resource
events
id_event
id_resource
¿name_resource?
I want that in the table events if the field id_resource match with the ...
- 9
0
votes
0
answers
97
views
Error: read ECONNRESET when trying to “strapi export” from EC2 instance with S3 as Upload Provider
I have a strapi project running on a t2.small EC2 instance, i didn’t use RDS the entire MySQL db is on the same EC2 instance along with all the strapi files.
nginx is setup on the instance too as a ...
- 101
1
vote
0
answers
610
views
【MySql】ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
I'm in trouble with creating user on MySql.
I can see that there is no 'root' user when I run the command below.
mysql> SELECT User, Host FROM mysql.user;
+--------------------+-----------+
| User ...
- 11
0
votes
0
answers
128
views
java.sql.SQLException: Access denied for user 'username'@'localhost' (using password: YES)
Database Connection Issue After Moving Website to AWS EC2 and RDS
I recently moved my website from a local environment to AWS EC2 and RDS.
After launching the EC2 instance and RDS, my website is ...
2
votes
0
answers
121
views
Upgrading AWS RDS DB from MySQL5 to MySQL8 - cannot connect in deployed environment
I have a PHP application running on AWS Elastic Beanstalk that, up to this point, has been utilizing a MySQL 5.7 RDS DB. I've attempted to upgrade that DB to MySQL 8 by creating a read replica of my ...
- 55
0
votes
0
answers
97
views
where is the default system variable value is configured in mariadb?
I am looking to find where the system variable "binlog_format" is configured in mariadb on EC2(10.3.29-MariaDB-0ubuntu0.20.04). However running "show variables" display the binlog ...
- 53
0
votes
1
answer
229
views
Issues connecting my Node.js backend to my AWS RDS MySQL database
how are you?
I'm having issues connecting my Node.js backend to my AWS RDS MySQL database. I migrated from Digital Ocean to AWS, which was working perfectly within Digital Ocean. However, after ...
- 113
6
votes
3
answers
7k
views
I'm using amazon linux and trying to install mysql in ec2, but I keep getting the error "GPG key a is already installed" It happens
I am currently trying to install mysql in ec2, but the "GPG key" error keeps occurring.
- errormessage
[root ec2-user]# sudo yum install mysql-community-server
Last metadata expiration check:...
- 97
0
votes
0
answers
72
views
AWS EC2 Instance Unable to Connect from Browser but MySQL Access via SSH Works - Mysql2::Error::ConnectionError in Rails Production Server
I'm currently facing an issue with my AWS EC2 instance, and I need some guidance to resolve it.
I'm a newbie and am trying to upgrade the Ubuntu version from 18.04 LTS to 20.04. After the version ...
- 15
0
votes
0
answers
34
views
Response is different on local and EC2 server
I have an API that would return a list of user with custom field.
The data in the database of EC2 is the same as local database. However, when I tried to posting a request, the response is different ...
- 1
0
votes
1
answer
34
views
In MySQL, how is it possible that a DATETIME column is AHEAD of the `updated_at` column with a `ON UPDATE CURRENT_TIMESTAMP` configuration?
Suppose I have a users table with a name_updated_at column (DATETIME DEFAULT NULL) and an updated_at column (DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
Also suppose I have an ...
- 1,851
0
votes
1
answer
540
views
What is the root user password for freshly installed MySQL? [duplicate]
I have an EC2 instance of AWS and I have installed MySQL through the following command:
sudo dnf install mysql80-community-release-el9-1.noarch.rpm -y
sudo dnf install mysql-community-server -y
Now ...
- 4,906