Re: privileges headache

2007-11-06 Thread Baron Schwartz
[EMAIL PROTECTED] wrote: Baron Schwartz wrote: hi, [EMAIL PROTECTED] wrote: GRANT SELECT, INSERT, UPDATE ON the_database.* -> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password'; Query OK, 0 rows affected (0.00 sec) FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) That statement doe

Re: privileges headache

2007-11-06 Thread mysql
Baron Schwartz wrote: hi, [EMAIL PROTECTED] wrote: GRANT SELECT, INSERT, UPDATE ON the_database.* -> TO [EMAIL PROTECTED] IDENTIFIED BY 'the_password'; Query OK, 0 rows affected (0.00 sec) FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) That statement does (at least) two things to

Re: privileges headache

2007-11-06 Thread Baron Schwartz
hi, [EMAIL PROTECTED] wrote: I rarely need to add users to a running setup but I always seem to run into the same sort of problem: I grant privs to a user but they refuse to show up. This user will be the one a web application goes through to access the DB. As the root user: GRANT SELECT, I

Re: privileges headache

2007-11-05 Thread mysql
[EMAIL PROTECTED] wrote: I rarely need to add users to a running setup but I always seem to run into the same sort of problem: I grant privs to a user but they refuse to show up. This user will be the one a web application goes through to access the DB. As the root user: GRANT SELECT, INSERT