RE: [PHP] mysql_connect
| From: | Paul Dale | Date: | Sun, 04 Aug 2002 10:48:37 +0000 |
| Subject: | RE: [PHP] mysql_connect | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111056@lists.php.net to get a copy of this message | ||
This is probably a mysql permissions issue not a php issue.
If you have admin rights on that database
GRANT ALL PRIVILEGES ON DATABASE_NAME.* TO
USER_TO_ALLOW_CONNECTIONS_BY@HOST_TO_ALLOW_CONNECTIONS_FROM;
(Where DATABASE_NAME is the mysql database to allow connections to, as in
"use database <x> in mysql")
followed by
FLUSH PRIVILEDGES;
in mysql as root.
Feel free to contact me offlist in the next few hours if you need help
determining if this is indeed the issue.
be well,
...paul
> -----Original Message-----
> From: Mantas Kriauciunas [mailto:Mantuks@attbi.com]
> Sent: Sunday, August 04, 2002 5:29 AM
> To: php-general@lists.php.net
> Subject: [PHP] mysql_connect
>
>
> Hey php-general,
>
> $db_host = "localhost";
>
> how do i set with ip ?
>
> it works with localhost
>
> but it doesn't work:
>
> $db_host = "IP.IP.IP.IP";
>
> or
>
> $db_host = "Http://IP.IP.IP.IP/";
>
> P.S IP i set numbers
>
> P.S.S i need to connet to mysql on other server
>
> thanks, sorry for dumb question....just can't find answer
>
> --
> Best regards,
> Mantas
>
> Contacts:
> Mantuks@attbi.com
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>