Re: Enable remote access to MySQL database server on wampserver

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Saqib,

It works. Thanks for your help.


Vichea

On Thu, Jan 28, 2010 at 4:38 PM, SAQIB <mr.saqi@xxxxxxxxx> wrote:

>
>
> Just use mysql 'GRANT' command for the database user to connect from 'any
> host', not from 'localhost', like that,
>
> mysql> GRANT ALL PRIVILEGES ON *.* TO myUser@localhost
> IDENTIFIED BY 'pass';
> mysql> GRANT ALL PRIVILEGES ON *.* TO myUser@"%"
> IDENTIFIED BY 'some_pass';
>
> "%" - is a wildcard in mysql. If you are defining your DB table and
> in the 'host' field enter '%', that means that any host can access
> that database (Of course, that host must also have a valid db user).
>
>
> On Thu, Jan 28, 2010 at 1:28 PM, Sovichea SOU <svch_sou@xxxxxxxxxxx<svch_sou%40yahoo.co.uk>>
> wrote:
>
> >
> >
> > Hi,
> >
> > I am using Windows XP with wampserver installed.
> > My local ip address is 192.168.5.62
> >
> > How can other computers access to MySQL database in my computer?
> >
> > Many thanks,
> >
> > Vichea
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> --
> Regards,
>
> Saqib.
>
>
> [Non-text portions of this message have been removed]
>
>  
>


[Non-text portions of this message have been removed]



------------------------------------

Are you looking for a PHP job?
Join the PHP Professionals directory Now!
http://www.phpclasses.org/jobs/
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-objects/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/php-objects/join
    (Yahoo! ID required)

<*> To change settings via email:
    php-objects-digest@xxxxxxxxxxxxxxx 
    php-objects-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    php-objects-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux