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.
1 2 3 4 5 |
[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
Abano
about 1 year ago
That was a very nice post, Im 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]
drawings bdsm
http://qaiguit.w8w.pl/bdsmtortfc/rnghig.html|bdsm whip Hi this is a very informative site! Save your time, please.