+34 699 336 339
Technical support Contact to us  
VirtualHostingDigital
WITHOUT PERMANENCE DOMINION INCLUDING   CERTIFICATE SSL FREE
IN ALL THE SERVICES IN ALL THE LODGINGS   FOR ALWAYS
Web Hosting | Domains | Resellers | Servers | Certificates SSL | Design Web | Center of Support and Help
YOU ARE IN   HOME €œFAQ - FREQUENT QUESTIONS
 
  FREQUENT QUESTIONS  
   
  BLOG  
 
 
 
08
SEP 2012
 

Problem when connecting to MySQL of remote form in CentOS

 

Sometimes we needed to connect to ours mysql from a program as navicat and we were that it shows a connection failure to us.

2003: Can't connect to MySQL server on €˜localhost€™ (10061)

It can be that we have put some bad data, but not always he is this and he is the servant who rejects the connection because the remote connection to mysql is not qualified.

In order to solve this, we will make the following thing:

1: To enter through ssh

To enter through SSH the Dedicated Servant or VPS

2 - To qualify Networking

Once connected you need to publish the configuration file my.cfg.

In CentOS the file is in /etc/my.cnf

nano /etc/my.cnf

3 - Once opened the file, it looks for the line that mysqld says []

To comment the line skip-networking or to clear it and to add the following one
line

bind-address = SU-SERVER-IP

For example, if your servant has the IP 100.100.100.100 then quedaria something
similar to this:

[Mysqld]
port = 3306
bind-address = 100.100.100.100

4 - To keep and to close the file and to reinitiate the service mysql.

/etc/init.d/mysql restart

 
<< To return back
 
VirtualHostingDigital VirtualHostingDigital
© - GreenLeafSoft Policy of Privacy | The Company | Conditions |
Contact Web Hosting Registry of Domains Recommended Webs
Other Sections Hosting Web WHOIS of Domains RevoGamers
Technical support Details of Hosting To register Domains The Best Finder
Design Web To modify Domains Life Hosting
Positioning SEO Resellers To renew Domains Georgescu Asosores
Certificates SSL Plans for Remarketers To transfer Domains Exclusively Professional
To renew Services Details of Resellers Mochilata
Policy of Cookies FAQ - Blog
RN-Esthetic Servers and Administration Frequent questions
GetStrong Dedicated servers Blog of the News
Jubellestetica Servers VPS Alba Piscinas
You want to obtain discounts? Servers of Mail Opinions of clients
Formatipica Administration of Servers Sight that thinks our clients
 
 
Academy of Police Schedule of Commercial Attention: 10:00 to 20:00 of Monday to Saturday - WhatsAPP:
+34 699 336 339
The prices that appear in the Web do not include 21% of IVA.