----- Original Message ----- From: "J.A. Jones Tyler III" <[EMAIL PROTECTED]>
> > I have gone into the user table in mysql db and placed > both 'localhost' and '%' into the host entry. It was > my understanding that '%' would allow access from any > host for that particular username. > Well, I finally specifically granted all priv's to username@"127.0.0.1' and was able to get it to work. Can someone give me the syntax for giving a user the right to access a dB or all dB's from any domain? I must be inputing it wrong. To recap, I was writing this : grant all privileges to dbname.* to username@"%" identified by 'password'; It took it and when I looked into the table, it showed it in there. But, whenever I tried to use php to connect, I'd get the error about access denied to [EMAIL PROTECTED] Only when I specifically entered the local host defaul ip as a host that username could connect from did it work. Thanks again for any help! jt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
