Re: semi-OT Grant Tables in MySQL

----- Original Message ----- From: "John Starkey" <jstarkey@advancecreations.com> To: <php3@developersdesk.com> Cc: <php-db@lists.php.net> Sent: Tuesday, January 09, 2001 1:14 AM Subject: Re: [PHP-DB] 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. If it is @localhost not root@localhost, you did not login mysql as root, you login as anonymous user, which by default does not have grant privilege. > > > > 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 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >