Sunday, December 12, 2010

Enable another host connect to our MySQL Server

In some condition we need to separate between database server from server which the application running on it. In MySQL version 5.1.33-community the default configuration only allow incoming connection from localhost or the machine itself.  In that condition any mysql client applications in another host can't access to the MySQL server. We need to modify configuration in the MySQL server in order to enable another allowed to create connection. The following instruction  is what I did to solve this problem:

If phpmyAdmin was installed  and running well

1. Open any web browser, and then access the phpmyAdmin Application, for example http://172.16.223.132/phpmyadmin



2. Select Privileges from tabs menu



3. Select the user who want to allow connect from anaother host



4. Modify host value from "localhost" to "any host"



Note:

if you are advanced user who familiar with SQL language or command line,  you can do this with DML (Data Manipulation Language) command to user table in mysql database.

1 comment:

  1. 고객을 위한 안드로이드 및 아이폰 등 스마트폰 모바일카지노 전문 우리계열 007카지노입니다. 온라인 주문에 특화된 풀필먼트센터의 전 단계를 실험하고 있는 것으로 해석될 수 있어서다. 물류 업계 관계자는 “코스트코와 새벽 카지노 계열 배송 제휴사는 CJ대한통운”이라며 “저녁 5시 전에 주문...

    ReplyDelete