in Education by
I want to connect to db on EC2 from my local machine, I am not able to do and have tried everything- I am using this command to connect to EC2: mysql -uUSERNAME -hEC2_IP -pPASSWORD This error is generated ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (110) I have modified my.cnf with skip networking bind-address = 0.0.0.0 Still not able to connect to the database Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
You can try looking into the following mentioned potential reasons that might be causing the error you are facing. Make sure that you edit the security groups and add a rule to allow remote access from your machine to your Amazon EC2 instance. MySQL will create a root user id by default which is only accessible from localhost. Which means that root user id and password will not work for the remote machine. To resolve this, you have to allow the root user to access MySQL from a remote machine. Also, verify if the local firewall of your machine is enabled or not. If not, then enable it and make sure that port 3306 is open.

Related questions

0 votes
    I have set up a micro instance server on EC2 based MySQL server fails frequently and for the third time, ... run/mysqld/mysqld.pid Select the correct answer from above options...
asked Feb 3, 2022 in Education by JackTerrance
0 votes
    I realize a couple of basic differences between the two, i.e. EC2 is going to be cheaper RDS I wouldn't ... just high SELECT volume. Select the correct answer from above options...
asked Feb 2, 2022 in Education by JackTerrance
0 votes
    I'm attempting to copy my MySQL database from an Amazon EC2 to an RDS: I successfully did a mysqldump of ... easy question. Thoughts? Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    I have thought a lot recently about the different hosting types that are available out there. We can get ... added probably. Thanks Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I want to use python to connect to a MySQL database, how can I do that? Select the correct answer from above options...
asked Jan 23, 2022 in Education by JackTerrance
0 votes
    I want to upgrade my Amazon EC2 micro (t1.micro) instance to large. Please help. Select the correct answer from above options...
asked Jan 25, 2022 in Education by JackTerrance
0 votes
    Any easy way to move and custom AMI image between regions? (North Virginia -> Singapore) I know you can mess up with ... way to do it? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    If you want to build enterprise ASP.NET MVC applications that use MSSQL databases is it better to use Windows ... integration, etc)? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I want to change the time zone set in my Amazon EC2 instance running Ubuntu Linux to local time. My Question ... zone in Amazon EC2? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    We have a large ec2 instance running in Asia pacific region. We want to reserve that particular instance.In aws ... out on something Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I need to know of any way to access a running instance in Amazon EC2. I DON'T have the original keypair ". ... or assign a new keypair? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I need to know of any way to access a running instance in Amazon EC2. I DON'T have the original keypair ". ... or assign a new keypair? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    How should I use the new AWS EC2 classes (r3, i2) with my existing AMI without recreating the whole system ... only PVM AMI images. Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    I need SSH access to an Amazon EC2 instance running Ubuntu. All I have is the Amazon username and password. Any ideas? Select the correct answer from above options...
asked Feb 4, 2022 in Education by JackTerrance
0 votes
    I am trying to stop an Amazon EC2 instance and get the warning message Warning: Please note that any data on ... Amazon EC2 instance? Select the correct answer from above options...
asked Feb 2, 2022 in Education by JackTerrance
...