A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this help?
Ben
Pam Astor wrote:
>> connectiong from shell means connecting as localhost by default, connecting
>> from PHP can be some different server and/or PHP uses the full IP
>> address/hostname of the server
>>
>> check/compare the privileges for your users for 'localhost' and '%'
>
>
>
> I ran “SELECT * from mysql.user;” the command generated a
> list. For root it showed in the host
> column local host, the second row for root showed the name of the web server
> the mysql install is on. The third and
> fourth rows showed no users, however the third and fourth rows showed in the
> host columns localhost and the server name, respectively.
>
>
>
> The fifth and sixth lines showed the first non root user I created
> and for this user it showed in the host Colum the % character, and the other
> line for this user showed localhost as the host.
>
>
>
> The seventh line shows the second non root user I created –
> it has just one line and shows localhost as the host. All the rest of the users I
> created show the
> % character in the host column.
>
>
>
> No IP addresses are listed anywhere.
>
>
>
> _________________________________________________________________
> More immediate than e-mail? Get instant access with Windows Live Messenger.
>
> http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008
