Thanks all ,, it's work with ,
i just add user and make grant ..
thanks again
--- Blaine <apelouperdeu@xxxxxxxxx> wrote:
> try switch $He = "192.168.1.68" for $He =
> "localhost".
>
> If you are usign the xampp so the mysql and the
> apache are in the same
> machine. If this is true you can call the mysql
> server by localhost.
> By default of security, the mysql not allow external
> acess to the
> database.
>
> If you really wanna to allow this, what is not
> recomended, for make
> possible someone invade your system for brute force,
> you will have to
> change the config of mysql what you can see how into
> the mysql site.
>
>
>
> On Jan 25, 2008 5:21 PM, Danitzel Jurado
> <valerie_nicole2000@xxxxxxxxx> wrote:
> >
> >
> >
> >
> >
> >
> > Hi Saeed:
> >
> > Let me understand ok.
> >
> > You mean others serves can access your database.
> >
> > You have one website in one server and other
> website in other server both
> > both is connecting to the server database.
> >
> > Saeed Mulla <saeedos@xxxxxxxxx> escribió: Hi
> Danitzel
> >
> >
> > i got the solution which is
> > grant all privileges on db_name.* to
> 'user'@'host'
> > identified by 'password';
> > flush privileges;
> >
> > So, since the MySQL server is 20, and your
> machine is
> > 21 the command will be:
> > grant all privileges on db_name.* to
> > 'user'@'192.168.1.21' identified by 'password';
> > flush privileges;
> >
> > Then on the php side you will do:
> > mysql_connect('192.168.1.20', 'user',
> 'password');
> >
> > but i have a small question ...
> > if i want to allow many users ( same ip range
> > 192.168.1.X ) to access this database ... what
> should
> > i do in host in mysql ??
> > in the previous solution i put in the host the
> value
> > of
> > one of this computer which is 192.168.1.21 ...
> > is there anything like 192.168.1.*.* or
> 192.168.1.x ??
> > thanks for everything
> > --- Danitzel Jurado
> <valerie_nicole2000@xxxxxxxxx>
> > wrote:
> >
> > > Mysql tools is similar to PhpMyadmin.
> > >
> > > It's for administration mysql.
> > >
> > > please go to the mysql site and download that
> tools
> > >
> > > Saeed Mulla <saeedos@xxxxxxxxx> escribió:
> > > i'm using XAMPP .. i'm using
> > > mysql and phpMyAdmin ...
> > > what the tools ??
> > >
> > > --- Danitzel Jurado
> <valerie_nicole2000@xxxxxxxxx>
> > > wrote:
> > >
> > > >
> > > > Do you install mysql tools on the database
> > > computer?
> > > >
> > > > Saeed Mulla <saeedos@xxxxxxxxx> escribió:
> > >
> > > > ok , what should i do and how
> > > ??
> > > >
> > > > --- Danitzel Jurado
> > > <valerie_nicole2000@xxxxxxxxx>
> > > > wrote:
> > > >
> > > > > Hi
> > > > >
> > > > > Probably you need to give the right
> > > permisions
> > > > for
> > > > > that connections into mysql.
> > > > >
> > > > > That's mean you need to create an instance
> > > on
> > > > > mysql that allowed that ip to do somenthing
> on
> > > > the
> > > > > database.
> > > > >
> > > > >
> > > > >
> > > > > SaEeDoS <saeedos@xxxxxxxxx> escribió:
> > > > > Hi all .
> > > > > i write a php script , and i want to
> connect
> > > to
> > > > > another pc in the same
> > > > > network that have a mysql database .
> > > > > i use mysql_connect function .
> > > > > <?php
> > > > > $DB_name = "wfdb";
> > > > > $He = "192.168.1.68"; // the ip of the pc
> that
> > > > have
> > > > > mysql
> > > > > $Ue = "emp";
> > > > > $Pe = "pass1";
> > > > > $connect = mysql_connect($He, $Ue, $Pe) or
> > > > > die('Connection ERROR');
> > > > > $select = mysql_select_db($DB_name,
> $connect)
> > > or
> > > > > die('Selection
> > > > > database error')
> > > > > ?>
> > > > > when i run the script i have this massege :
> > > > > mysql_connect() : HOST 'saeed-980XXXX ' is
> not
> > > > > allowe to connect to
> > > > > this MySQL server .
> > > > > what should i do ??
> > > > > is there any setting that i must put it in
> > > mysql
> > > > ?
> > > > > please tell me
> > > > >
> > > > > thanks
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Danitzel Jurado
> > > > >
> > > > > celular: 6727-0315
> > > > >
> > > > >
> > > > > ---------------------------------
> > > > >
> > > > > ¡Capacidad ilimitada de almacenamiento en
> tu
> > > > correo!
> > > > > No te preocupes más por el espacio de tu
> > > cuenta
> > > > con
> > > > > Correo Yahoo!:
> > > > > http://correo.espanol.yahoo.com/
> > > > >
> > > > > [Non-text portions of this message have
> been
> > > > > removed]
> > > > >
> > > > >
> > > >
> > > > If I Know It ...
> > > > I Can Do It ...
> > > >
> > > >
> > > >
> > >
> > >
> >
>
__________________________________________________________
> > > > Looking for last minute shopping deals?
> > > > Find them fast with Yahoo! Search.
> > > >
> > >
> > >
> >
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> > > >
>
=== message truncated ===
If I Know It ...
I Can Do It ...
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
