Re: [PHP-DB] MySQL CONNECTION PROblem

2003-06-10 Thread nabil
but when i used mysql_error() i got : "sorry database not found" and i have privileges in mysql/ user table .. as shown below... the point is if i changed 192.168.0.111 to localhost .. i managed to get the data ... as my dbconnect.php file includes and the user table of mysql database : # # Du

Re: [PHP-DB] MySQL CONNECTION PROblem

2003-06-10 Thread George Patterson
On Tue, 10 Jun 2003 16:47:26 +0300 "nabil" <[EMAIL PROTECTED]> wrote: > but when i used mysql_error() i got : "sorry database not found" > > as my dbconnect.php file includes > > mysql_connect("192.168.0.111" , "root" , "password") or die("SORRY > CANNOT CONNECT") ; > mysql_select_db("kt") or

Re: [PHP-DB] MySQL CONNECTION PROblem

2003-06-10 Thread nabil
but when i used mysql_error() i got : "sorry database not found" as my dbconnect.php file includes and the user table of mysql database : # # Dumping data for table `user` # INSERT INTO user VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y')

RE: [PHP-DB] MySQL CONNECTION PROblem

2003-06-09 Thread John W. Holmes
> i have the dbconnect.php as : > // > mysql_connect("192.168.0.111" , "root" , "pass") or > die ("Couldn't connect to database"); > mysql_select_db("DatabaseName") or > die("sorry database not found"); > ?> > /// > when i put localhost instead of the IP address of

Re: [PHP-DB] mySQL connection problem

2001-04-29 Thread winescout
Check to see that mySQL is running on your system. On mine, when it is not, I get an error just like that. Matt ""LENNART KARLSSON"" <[EMAIL PROTECTED]> wrote in message 9cefep$4pu$[EMAIL PROTECTED]">news:9cefep$4pu$[EMAIL PROTECTED]... > Hi! > I have a problem when I try to use a mySQL connecti

Re: [PHP-DB] MySQL connection problem - need help from expert

2001-03-22 Thread Ian
Thanks, Thor and Cal ; ) "Ian" <[EMAIL PROTECTED]> wrote in message 99eaaj$njn$[EMAIL PROTECTED]">news:99eaaj$njn$[EMAIL PROTECTED]... > Please help me !!! > > Description :- > Server 1 is installed MySQL which located in US. > Server 2 is

RE: [PHP-DB] MySQL connection problem - need help from expert

2001-03-22 Thread Cal Evans
Greetings and Salutations Ian, Somewhere in your code you are going to have a line similar to this: $currentConnection = mysql_connect ($server, $userName,$password) $server is going to be either the name or the IP address of your server $userName is going to be the MySQL user name you use to co

RE: [PHP-DB] MySQL connection problem - need help from expert

2001-03-22 Thread Thor M. Steindorsson
In the 'user' table in the 'mysql' database on server1, you need to insert the username you'll be using to connect (and the encrypted password), and in the Host field you have to specify the hostname of server2, as well as what privileges you want that user to have (I recommend nn, the