U
U
Urukhayy2015-06-02 15:37:06
MySQL
Urukhayy, 2015-06-02 15:37:06

Why is mysql not connecting to a remote mysql database?

Why is mysql not connecting to a remote mysql database?
Centos 6.6, apache.

Answer the question

In order to leave comments, you need to log in

4 answer(s)
A
Alexander Aksentiev, 2015-06-02
@Sanasol

Because Apache is a webserver and doesn't use mysql at all?

G
Gregory, 2015-06-02
@difiso

What error is being thrown? What does Google say about this? Server just installed? Does he listen to interface 0.0.0.0 or only 127.0.0.1? Is port 3306 open to outside access? Please clarify.

A
Alexander, 2015-06-05
@Tilk

1) The default mysql server only allows you to login from localhost. You need to change the permissions for the user or create a new one with the appropriate privileges.
2) The remote server is behind a firewall.
3) What Gregory writes about =)

S
ShamblerR, 2015-06-08
@ShamblerR

1 comment out the following line on the sql server in my.cnf
bind-address = 127.0.0.1
and restart the sequel
2. try to connect via telnet is there a connection at all?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question