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
> >
> >
> >
> >
> >
> > 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 ...
>
>
>
__________________________________________________________
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs
>
>
>
>
>
> 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
