brianwebb.org

How-To Enable MySQL remote connections

Wed, May 28, 2008 - 140 comments

By default MySQL only permits connections from the server on which it resides.

Using SSH you need to connect to your server, then need to edit the my.cnf file, generally located in /etc/mysql/my.cnf on Debian/Ubuntu

Under the [mysqld] section alter the “bind-address” line to bind to the public IP address of the server instead of the loop back IP.


[mysqld]
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysqld.socket
bind-address=127.0.0.1

Save the file then restart the MySQL service (# /etc/init.d/mysqld restart)

Now using the MySQL admin tool of your choice create your user accounts but specify the host that they will be connecting from. For example if you are creating a user that connects from the IP address 80.65.35.43 the username will be in this format: username@80.65.35.43

MySQL, Linux

Comments

Abano

over 2 years ago

That was a very nice post, I�m proud of you! hello, your site is lucky. bdsm vip [url=http://qaiguit.w8w.pl/bdsmtortfc/jugleeleni.html] brainwashing and bdsm [/url] http://qaiguit.w8w.pl/bdsmtortfc/rcusthou.html|extreme pain slave bdsm [url=http://qaiguit.w8w.pl/bdsmtortfc/zdeburirri.html] christian bdsm personal ads [/url]

8 months ago

geo tracker 4x4 rebuilt geo metro manual transmission cheap geo prizm rims geo tracker mustang 1997 geo metro manual transmission [url=http://geo.fh10.net/geo-da-silva.html]geo da silva[/url] [url=http://geo.fh10.net/tires-geo-tracker.html]tires geo tracker[/url] geo tracker repair geo thermal heating and cooling variablegeo torrent neo geo tracker engines geo scout free download geo group tacoma 1994 geo prism heater geo exchange heat pump geo tracker mustang geo prizm replacement parts [url=http://geo.fh10.net/geo-location-map-philippines.html]geo location map philippines[/url] [url=http://geo.fh10.net/geo-thermal-tax-incentives.html]geo thermal tax incentives[/url] geo prism mapquest geo accuracy 1996 geo prizm tires 1998 geo tracker global geo supplies littleton

royataPoods

8 months ago

lincoln mig welder lincoln welding helmets lincoln generator lincoln welding helmet lincoln generators [url=http://lincoln.byethost6.com/lincoln-stickwelders.html]lincoln stickwelders[/url] [url=http://lincoln.byethost6.com/lincoln-welder-parts.html]lincoln welder parts[/url] the truth about abraham lincoln lincoln stickwelders lincoln brewster lincoln county transit lincoln plasma cutting lincoln ne nash metropolitan lincoln arc welders assassination of abraham lincoln lincoln mig welder lincoln welding company [url=http://lincoln.byethost6.com/hot-rod-lincoln.html]hot rod lincoln[/url] [url=http://lincoln.byethost6.com/tad-lincoln.html]tad lincoln[/url] lincoln mig welders lincoln passenger vehicles e bay motors assassination of abraham lincoln lincoln crossover vehicle lincoln continental bill blass

I’m Brian Webb, and this site is my personal portfolio and blog. I am a software developer, designer, and all around technology evangelist. Here you will find the latest projects that I've worked on as well as some of the problems and ideas that I'm currently tackling or pondering.

I program in a wide array of languages and frameworks, including Ruby, Ruby On Rails, ActionScript, Flex, PHP, ASP.NET, C#, VB, Java, Perl, Python, C/C++ and others. I also have experience in information security and systems architecture and administration on platforms such as Windows Server, Linux, OS X, BSD and others.

The challenge of creating something from nothing is what drives me, not just to create software, but to learn and adapt to the changing needs of the industry to always be on the cutting edge.

Quick Contact form

If you have a question or comment, this form should fit your needs. If you are interested in a project quote, the contact page may be a better solution.

Contact Form

Comments

Frurnereosorb

DantDeems

EmaliaCoale

utipstierne

experralmAbraps

rultippiliosy

tertJiliono

gofsReode

Charlypap

Drearmerync

About - brianwebb.org

Recent Blog Topics