sorry replace "userx' instead of "php". actually i used userx instead of the actual php. but i started the post using userx.

Tata Respecia <tata...@yahoo.com> wrote: I made the grants thru 3rd party SQLyog but didnt get the desired result. i also
tried using mysql prompt but still the same.

however i remember i just copied dbx database using windows simple explorer
copy/paste from my old server harddisk to this new one. I suspect this is the
reason. if this is so, how can i find some remedy?

mysql> select host,user from user where user='php'; +------+----------+ | host | user | +------+----------+ | % | userx | +------+----------+ 1 row in set (0.00 sec) mysql> select host,db,user from db where user='php'; +------+------+------+ | host | db | user | +------+------+------+ | % | dbx | php | +------+----+------+ 1 row in set (0.01 sec)

"Jonathan G. Lampe" wrote:Hello Tata,

It would probably help if you: - Posted the exact commands you are using to grant access to "userx" - Posted the results from your "mysql" database using these two queries: mysql> select host,user from user; mysql> select host,db,user from db;

-jgl