[PHP-DB] Re: MySQL CONNECTION PROBlem2

2003-06-10 Thread nabil
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
die(sorry database not found);
?

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');
INSERT INTO user VALUES ('%', 'root', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', 'N', 'Y', 'N', 'N', 'N');
INSERT INTO user VALUES ('localhost', '', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO user VALUES ('%', '', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', 'N', 'N', 'N', 'N', 'N');

so it has the '%' value so it can be accessed by any host.!!!1

any comment ???


Cristian Marin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
You don't have the rights to connect to the MySQL server with
[EMAIL PROTECTED] You have to add this user to the mysql users table and to
allow him to do the needed actions. Also you have to modify the hosts table.
--
-
Cristian MARIN
InterAKT Online (www.interakt.ro)
+4021 411 2610
[EMAIL PROTECTED]

  Nabil [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
  Sorry , when i put the IP instead of localhost  i got the error...







-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Re: MySQL CONNECTION PROBlem2

2003-06-09 Thread Cristian MARIN
You don't have the rights to connect to the MySQL server with [EMAIL PROTECTED] You 
have to add this user to the mysql users table and to allow him to do the needed 
actions. Also you have to modify the hosts table.
-- 
-
Cristian MARIN
InterAKT Online (www.interakt.ro)
+4021 411 2610 
[EMAIL PROTECTED]

  Nabil [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
  Sorry , when i put the IP instead of localhost  i got the error...