Re: semi-OT Grant Tables in MySQL

> > "GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY > > 'passwd'; > > > > Is returning SYNTAX OK 0 rows affected and access denieds. > > > > Can anyone tell me what's going on? I can access it without > > specifying a user. And with PHP I get @localhost denieds. > > The GRANT command looks valid. What is the exact error message? It just dies. No feedback except the above. > You are doing this from the mysql command line interpreter, right? Yeah. > What user did you connect as? root > For most PHP access to a database I would use: > > GRANT INSERT,DELETE,UPDATE,SELECT ON database.* TO someuser@localhost > IDENTIFIED BY 'password'. I'm setting up me for grant all and another user with the above privs for the php scripts. I need to mirror a db that's already online and functional as far as the php user & privileges go. I created the db.user table by hand and it's working. Just sucks doing all the work when there's a script that should take care of it for you. Thanks, John