Remotely Access MySQL database......

[lakindu93]

yaluwane... mata podi udawak oni......

PC1 eke wamp server dala tiyenawa..... PC2 eke netbeans wala karana java project ekak tiyenawa... mata oni PC2 eke idan PC1 eke thiyena mysql database eka access karana.... meka karanne kohomada???

PC1 = 192.168.1.1
PC2 = 192.168.1.2

PC dekama ping wenawa... depathatama..

wamp server eke phpmyadmin.conf file eke meka edit kala(Allow from all)
ethakota phpmyadmin access karanna puluwan PC2 eke idan....
eth mysql database eka access karanna ba ne.....
eke monawahari remote settings enable karanna tiyenawa da?......

java project eke code eka liyala tiyenne mehemai...

DriverManager.getConnection("jdbc:mysql://192.168.1.1:3306/test", "root", "abc123");

 

[lakindu93]

bump....

 

[hans078]

Machan PC1 eke Firewall eke settings balapan tikak... Firewall eka down karala access karanna tey ekak diyan....
​

 

[ad.hasareli]

hoda prashnayak matat dena ganna oni.....

 

[kavindagk]

1. oya balannea PC2 eke WEB BROWSER eka use karala PHPMYADMIN page ekata log wennea puluwanda kiyala ehema puluwannam oyata karannea thiyennea MYSQL wala thiyanawa REMOTE ACCESS enable karana widiyak[mata WAMP eka karana widiya mathaka na]

"http://www.namecheap.com/support/knowledgebase/article.aspx/1267/89/"
"http://kosiara87.blogspot.com/2011/03/allow-remote-access-to-apache-on-wamp.html"

me link 2ka balannea....

 

[hspa3.5]

oya mukuth one na pc1 eke mysql server 1ke menna meaka gahala execute karapan

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

ita passe pc2 1kn pc1 eke MYSQL vala root access kalahaki root gen call karapan

nathnam pc1 MYSQL vala user kenek hadala uta DB access dipan pc2 1kn e user through call karapan

2ma vada


api giya vade hari giyoth PM 1k dapan

 

[Red Soda]

pc1 eke firewall eka off karala balanna

 

[kudalla]

uncomment below ling in mysql.conf (my.conf in most of linux servers not sure about windows file name )
bind-address = 127.0.0.1

 

[Dave_lich]

if it still doesn't work..try this.

Stop wamp MySQL Service
Download MySQL Essential 5.1 to your platform
Tick Enable root access from remote machines in configuration wizard

Use SQLyog to database management

 

[NO_MeRcY]

uncomment below ling in mysql.conf (my.conf in most of linux servers not sure about windows file name )
bind-address = 127.0.0.1

Mulin mysql/my.conf file eke line eka bind-address = 127.0.0.1 # ekak daala comment karala mysql restart karanna..

eeta passe

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

me command eken onema external dynamic ip ekakata remote allow karanna puluwan.

eta passe flush karapan

[FONT=arial,helvetica,sans-serif]mysql> flush privileges;

echcharai
[/FONT]

 

[lakindu93]

1. oya balannea PC2 eke WEB BROWSER eka use karala PHPMYADMIN page ekata log wennea puluwanda kiyala ehema puluwannam oyata karannea thiyennea MYSQL wala thiyanawa REMOTE ACCESS enable karana widiyak[mata WAMP eka karana widiya mathaka na]

"http://www.namecheap.com/support/knowledgebase/article.aspx/1267/89/"
"http://kosiara87.blogspot.com/2011/03/allow-remote-access-to-apache-on-wamp.html"

me link 2ka balannea....

ow machan.. phpmyadmin use karanna puluwan....
thanks man link 2 balala try ekak dennam....

 

[lakindu93]

uncomment below ling in mysql.conf (my.conf in most of linux servers not sure about windows file name )
bind-address = 127.0.0.1

mysql.conf kiyanne my.ini kiyana file ekatama da?
my.ini kiyana file eke bind-address = 127.0.0.1 kiyala ekak na ne....

 

[lakindu93]

Machan PC1 eke Firewall eke settings balapan tikak... Firewall eka down karala access karanna tey ekak diyan....
​

pc1 eke firewall eka off karala balanna

firewall eka off kalata hari giye na.... pc dekema off kala...

 

[lakindu93]

oya mukuth one na pc1 eke mysql server 1ke menna meaka gahala execute karapan

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

ita passe pc2 1kn pc1 eke MYSQL vala root access kalahaki root gen call karapan

nathnam pc1 MYSQL vala user kenek hadala uta DB access dipan pc2 1kn e user through call karapan

2ma vada


api giya vade hari giyoth PM 1k dapan

Mulin mysql/my.conf file eke line eka bind-address = 127.0.0.1 # ekak daala comment karala mysql restart karanna..

eeta passe



me command eken onema external dynamic ip ekakata remote allow karanna puluwan.

eta passe flush karapan

[FONT=arial,helvetica,sans-serif]mysql> flush privileges;

echcharai
[/FONT]

Hariiiii hari giya...... thanks lot help karapu okkoma ayata......

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
mysql> Flush Privileges;

me query deka execute karahama hari giya.....