Re: [plug] connect to MySQL Server from Internet...

Sun, 25 Jun 2006 23:25:28 -0700

I recommend binding to a specific IP instead of the % wildcard and be database specific. But hey, it's your box, your choice.

On 6/26/06, Roger Filomeno <[EMAIL PROTECTED]> wrote:
 
mysql> grant all on *.* to username@'%' identified by 'password';
mysql> flush privileges;
 
then make sure to open your iptables by adding to script:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
 
reload your firewall then you might want to restrict it to specified IP's only tho


 
On 6/26/06, jan gestre <[EMAIL PROTECTED] > wrote:


On 6/26/06, Alexander Santiago < [EMAIL PROTECTED]> wrote:

Thanks po for the response....
Yes.

Just grant privileges to a user and the host. Check your my.conf too.

Something like this should work:

grant all privileges on test.* to 'guest'@' 192.168.1.2' identified by 's33kr3t';

what IP shouild I use? the computer that I am connecting to is connected to a LAN and all the workstations have the same IP address....

 
are you sure about this? all clients have the same ip address, how did that happen? does your mysql server have a public ip? if it does then you can use phpmyadmin to administer your database and make sure that apache and php are installed to make it work. if the network address of the server your trying to access is the same as your LAN then you have to open up the mysql port in your firewall/router and use vpn to connect to it.


HTH
 

On 6/26/06, Alexander Santiago < [EMAIL PROTECTED] > wrote:
Good day!

Is it possible to access MySQL server through the internet? How?



--
Alexander P. Santiago
Registered Linux User # 384399
another Forever Linux Newbie

_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph




--
V irus
I nstability
S pyware
T rojans
A dware

_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph




--
--
MSG GODIE <YOUR MESSAGE>
then send to 2948 for Globe/Sun and 3940 for Smart. Get yours FREE at www.Txtmokko.com
--
Roger P. Filomeno
Mobile Specialist / R&D
Finger Apps Inc, http://fingerapps.com
Blog: http://corruptedpartition.blogspot.com/

_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph




--
John Peter Loh
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph

Reply via email to