Re: Fwd: Re: [PHP] dumb mysql_connect issue
| From: | Alexander Wagner | Date: | Tue, 31 Jul 2001 23:02:53 +0000 |
| Subject: | Re: Fwd: Re: [PHP] dumb mysql_connect issue | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-60531@lists.php.net to get a copy of this message | ||
CGI GUY wrote:
> " Access denied for user: 'username@hostname' to
> database 'tablename' "
>
> 1. The uid/password set I am using has full
> privileges.
> 2. *tablename* is not a database (the code I listed in
> my previous email is syntactically identical to the
> script)-- it's a table.
>
> Why is this happening to me?!?! ;)
FROM table_name.column_name
is interpreted as
FROM database.table_name
Hence the confusion of database and table-names.
"FROM table_name" will suffice.
regards
Wagner
--
Madness takes its toll. Please have exact change.