thank you sir,and i got the solution.it is 1> At the console of the box on which mysql server is running type mysql -uroot -p 2> It will prompt you for root pasword is it was set. Once insidew mysql command shell type user mysql; 3> now type the following command: grant all privileges on *.* to '<username>'@'<IP>' identified by '<password>'; In above command replace <username> with the username you want for connection.<IP> with the IP of the host from where you want the permission to connect to this mysql server(in you case this shall be 192.168.1.2) You can also use 192.168.% to allow connection from all IP that begin eith 192.168. Similarly replacing <IP> with just % will allow connection from all hosts for this username. Replace <password> with the password you want. 4> type this command: flush privileges;
on, Aug 29, 2011 at 4:22 AM, Willy Mularto <sangpr...@gmail.com> wrote: > Well this is not Kannel's topic I guess. Check your my.cnf is it allowing > other host to connect? After that add privilege in your MySQL to the host you > want to connect from. > > > > On Aug 29, 2011, at 5:39 AM, Vijay kumar Dadhich wrote: > >> Hello to all, >> I am using kannel with dlr-storage = mysql successfully,and i want to >> use SQLBOX in kannel application,we >> want to connect our sql server(192.168.19.1) to linux's mysql >> server(192.168.19.4). >> My flow is look like as >> web/user interface-->SQL Server(another server)-->KANNEL (i think >> after SQLBOX flow is look like >> as)-->bearerbox-->send_sms-->sent_sms-->smsbox(mysql) >> >> >>> In LAN we are connected these three server-2 windows >> 1.windows server(web/user interface)-192.168.19.3 >> 2. database serve (sql server)-192.168.19.3 >> 3.192.168.19.4 >> Now i am using these step to connect mysql database. >> # /sbin/iptables -A INPUT -i eth0 -s 192.168.19.4 -p tcp >> --destination-port 3306 -j ACCEPT >> # service iptables save >> # iptables -F >> >> #/etc/init.d/mysqld restart >> # service iptales start >> when i do telnet then it is not connect with mysql telnet is showing >> this message. please find the attachemts,which is snapshoots of telnet >> with three ipaddress 1. 192.168.19.4 2. 127.0.0.1 >> 3.192.168.19.1 it is showing like this for linux ip. >> >> telnet 192.168.19.4 3306 >> trying 192.168.19.4... >> connected to 192.168.19.4 (192.168.19.4). >> Escape charcter is '^]'. >> EHost '192.168.19.4' is not allowed to connact to this MySQL >> serverConnection closed by foriegn host >> please help me it's urgent. >> >> telnet 192.168.19.1 3306 >> trying 192.168.19.1... >> telnet: connect to address 192.168.19.1 : connection refused >> telnet: unable to connect to remote host : connection refused >> >> telnet 192.168.19.4 3306 >> trying 192.168.19.4... >> connected to 192.168.19.4 (192.168.19.4). >> Escape charcter is '^]'. >> 4. >> 5.0.77c/%@PU7T,$QMof2e(5qYM after some second Connection closed by foriegn >> host >> >> I can't undestand,please help me.please help me it's urgent. >> -- >> Vijay Kr. Dadhich >> > > Willy Mularto > F300HD+MR18DE (NLC1725) > http://www.binbit.co.id/ > > > > > > > > > -- Vijay Kr. Dadhich
