1130 Host 'amazon-ec2-ip' is not allowed to connect to this MySQL server -

-

i facing problem in accessing mysql db on 1 of amazon ec2 servers ec2 server. read through various articles regarding providing appropriate permissions mysql accessed external ip addresses, , here steps followed:

  1. opened port 3306 on host ec2 instance allow external mysql connection.
  2. in file /etc/mysql/my.cnf, changed "bind-address" "127.0.0.1" "0.0.0.0".
  3. opened mysql using root, , executed following command: grant privileges on . worker@'ec2-ip-address' identified 'password';

as per blogs/articles read, should have solved issue, keep getting following error:

1130  host 'amazon-ec2-ip' not allowed connect mysql server

the ip address providing ec2 instance elastic ip gets generated when create instance. verify whether issue specific ec2, tried executing command "3" different "static ip address". now, worked me (i.e. able login mysql host remote server), sure above steps correct.

why amazon ec2 ip address not working?

after posting problem, working, realized wasn't able ping ec2 server or telnet it. basic had wrong. friend helped me out problem. had expected, problem specific ec2.

the details follows:

when create ec2 instance, external ip address similar to: ec2-xx-xxx-xxx-xx.ap-southeast-1.compute.amazonaws.com

while setting permissions in mysql granting permissions above ip address, i.e.:

grant privileges on . worker@'ec2-xx-xxx-xxx-xx.ap-southeast1.compute.amazonaws.com' identified 'password';

this not work when try communicate ec2 instance local ec2 instance. this, need provide 'internal ip address" of ec2 instance, can found using ip command:

ip a:

1: lo: <loopback,up,lower_up> mtu 16436 qdisc noqueue state unknown  link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 ::1/128 scope host  valid_lft forever preferred_lft forever  2: eth0: <broadcast,multicast,up,lower_up> mtu 1500 qdisc pfifo_fast state qlen 1000 link/ether 12:31:41:02:58:47 brd ff:ff:ff:ff:ff:ff inet **xx.xx.xx.xxx/23** brd yy.yyy.yy.yyy scope global eth0 inet6 fe80::1031:41ff:fe02:5847/64 scope link  valid_lft forever preferred_lft forever

to things working correctly, need grant permission ip address --"xx.xxx.xx.xxx/23", , should work. similarly, while connecting "mysql" database, hostname provided mysql command should "internal ip address" of host ec2 instance.


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c++ - Using OpenSSL in a multi-threaded application -

-
i have been writing soap client application in c++ on ubuntu using openssl https transport , pthreads threading. have number of threads - 1 central data acquisition thread periodically gets worker threads make soap requests via shared mutex protected queues. reading documentation openssl found is openssl thread-safe? in openssl faq describes mechanisms required ensure thread safety when using openssl. implemented , works fine. the reason question conceptual difficulty really. thinking implementing same functionality application has already, instead of using threads, create 2 seperate applications : 1 worker thread (of multiple copies running) , main data acquisition thread. use tcp sockets communicate between 2 rather mutex protected queues. may bad idea not important - confusing me would have implement same functions required ensure openssl thread safety in second approach or not? my guess not have , treated independent (indeed surely must many applications use openssl) re...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more