SOLVED.
On Wed, Aug 6, 2014 at 1:04 PM, Arun Khan wrote:
> On Wed, Aug 6, 2014 at 12:38 PM, Arun Venkataswamy wrote:
>>
>> Is the mysql server listening on all interfaces?
>> I think by default it listens only on localhost or 127.0.0.1
>>
>
> Yes, bind_address=0.0.0.0 (allow connection from any
On Wed, Aug 6, 2014 at 4:18 PM, Baskar K wrote:
> Hi,
> Though sounds silly, have you set the password
Yes. I have also solved the OP. see the other original thread.
-- Arun Khan
___
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
On Wed, Aug 6, 2014 at 12:38 PM, Arun Venkataswamy wrote:
>
> Is the mysql server listening on all interfaces?
> I think by default it listens only on localhost or 127.0.0.1
>
Yes, bind_address=0.0.0.0 (allow connection from any IP number).
> Another naive point, just to be sure : Have you open
On Wed, Aug 6, 2014 at 12:36 PM, Saravanakumar Karunanithi
wrote:
> Does your security group allow the mysql port 3306?
Yes.
>
> is IPTables blocking the port?
No. there is no rule.
>
> check using the following command
>
>
> *telnet aws-appsrv 3306 *
Yes this works. Checked all of the abov
On Wed, Aug 6, 2014 at 12:09 PM, Arun Khan wrote:
> I have 2 AWS instances (CentOS 6.5 64bit AMI)
> (a) Apache, PHP, mysql client package (IP = A, alias name aws-appsrv)
> (b) mysql-server (IP = B alias name aws-dbsrv).
>
> I have configured mysql server on B to accept connections on 3306 from A
Does your security group allow the mysql port 3306?
is IPTables blocking the port?
check using the following command
*telnet aws-appsrv 3306 *
On Wed, Aug 6, 2014 at 12:09 PM, Arun Khan wrote:
> I have 2 AWS instances (CentOS 6.5 64bit AMI)
> (a) Apache, PHP, mysql client package (IP = A
On Wed, Aug 6, 2014 at 12:16 PM, Balasubramaniam Natarajan
wrote:
> On Wed, Aug 6, 2014 at 12:09 PM, Arun Khan wrote:
> 1. Could you try logging in locally by adding an appropriate grant
> statement ?
>
> 2. Try using the FQDN for the grant statement on mysql
> server.
>
On Wed, Aug 6, 2014 at 12:09 PM, Arun Khan wrote:
> I have 2 AWS instances (CentOS 6.5 64bit AMI)
> (a) Apache, PHP, mysql client package (IP = A, alias name aws-appsrv)
> (b) mysql-server (IP = B alias name aws-dbsrv).
>
> I have configured mysql server on B to accept connections on 3306 from A
