[PHP] PHP+MYSQL: unable to select database

2001-12-10 Thread josep

 I get:
 
 unable to select database
 
 when I visit my guestbook.php
 
 The user trying it is set in the mysql.user (without any perms) and in the
 mysql.db (with all perms).

Do I have to set all perms to this user in the mysql.user table?
 
Josep


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] PHP+MYSQL unable to select database

2001-12-10 Thread josep

I can't select a database from a php script.

I've set privileges in both the user and the data base tables
and I've done FLUSH PRIVILEGES;

WHY?

JOSEP.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] PHP+MYSQL: unable to select database

2001-12-10 Thread Jon Farmer

 I get:

  unable to select database

  when I visit my guestbook.php

  The user trying it is set in the mysql.user (without any perms) and in
the
  mysql.db (with all perms).

 Do I have to set all perms to this user in the mysql.user table?

Did you 'flush privileges' ?

--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] PHP+MYSQL: unable to select database even FLUSH PRIVILEGES

2001-12-10 Thread josep

I've did:

FLUSH PRIVILEGES

but nothing changes.

Josep.



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP] PHP+MYSQL unable to select database

2001-12-10 Thread Miles Thompson

Have you checked the docs? Have you double-checked the username, password 
and permissions?
Have you added  or die(mysql_error()) to your database connection function?
If this site is remote, does your username/password have rights to access 
the database?

Good luck - Miles Thompson

At 11:58 AM 12/10/2001 +0100, josep wrote:
I can't select a database from a php script.

I've set privileges in both the user and the data base tables
and I've done FLUSH PRIVILEGES;

WHY?

JOSEP.


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]