I am new to mysql. In my sql database I have created a user and gave it the host '%' rather than localhost, this is so it will allow any host to connect to it. When I try to connect to the DB with the command "
" I get a "ERROR 2005 (HY000): Unknown MySQL host '%' . I am logged in as the root@localhost when trying to do this. I am sure that I have to modify some particular file but not sure which? Thanks in advance for any help.
Twb