On the MySQL terminal:
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');
On Jan 25, 2008 4:34 PM, Saeed Al Mullah <[EMAIL PROTECTED]> wrote:
>
> should i add a new host and user and give him a grant ??
> what should the host be ?? is it the same ip of mysql machine :
> 192.168.1.20 ??
> please somebody tell what should id ...
> i've read about this and all the site ( mostly ) says i should add new
> host ..
> i've learn how to add host and user .... but nothing work , i give all
> the grant option to the new user and host ,,, nothing happen .....
> i'm stuck in this ,,,,, i feel bad . i must finish this today coz
> tomorrow i have to show the script to my manager in work ....
>
> >
>
--
Al-Faisal El-Dajani
Phone: +962-7-79737050
P.O Box: 140056
11814 Amman, Jordan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Jordan PHP Users Group" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/JoPHP
http://Jolug.org/
-~----------~----~----~----~------~----~------~--~---
