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
> >
> >
> >
> >
> >
> > 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
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]
