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]

[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]

[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 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

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]