user d/b access

2004-01-06 Thread mark
Just fired up mysql 3.23.53 * Created a d/b, and then created an admin user for that d/b, using GRANT ALL ON URCMS.* TO urcms_admin IDENTIFIED BY 'changeme' WITH GRANT OPTION; Ok, it never prompts me for a password, nor did it let me, as that user, use URCMS. I looked in

Re: user d/b access

2004-01-06 Thread Michael Wittmann
Hi mark, I would recommend to use GRANT ALL ON URCMS.* TO 'urcms_admin'@'localhost' IDENTIFIED BY 'changeme' WITH GRANT OPTION; if you only need to connect to URCMS database from localhost. HTH Michael mark wrote: Just fired up mysql 3.23.53 * Created a d/b, and then

Re: user d/b access

2004-01-06 Thread mark
On Tuesday 06 January 2004 03:27 pm, Michael Wittmann wrote: I would recommend to use GRANT ALL ON URCMS.* TO 'urcms_admin'@'localhost' IDENTIFIED BY 'changeme' WITH GRANT OPTION; if you only need to connect to URCMS database from localhost. The problem is that I'm

Re: user d/b access

2004-01-06 Thread Ari Davidow
At 01:56 PM 1/6/2004, you wrote: Just fired up mysql 3.23.53 * Created a d/b, and then created an admin user for that d/b, using GRANT ALL ON URCMS.* TO urcms_admin IDENTIFIED BY 'changeme' WITH GRANT OPTION; Yup. Well known privileges problem. The short answer is that the