This is really a MySQL question,
  But you need to GRANT the user you created permissions to use the
MYSQL database.  Use the root user to do the grant.

see: http://www.mysql.com/doc/en/Adding_users.html
 Get Paul Dubois' excellent book. MySQL Second Edition ( Sams
Publishing).  It's great!
Also try [EMAIL PROTECTED]

Hope this helps
Ken
----- Original Message ----- 
From: "Xpression" <[EMAIL PROTECTED]>
To: "FreeBSD-questions" <[EMAIL PROTECTED]>
Sent: Monday, July 07, 2003 2:17 PM
Subject: Users question...


>         Can I have a special account to manage a specific service,
> specifically MySQL. I mean, I running MySQL as mysql user, but when
I want
> to update the database I have to login as root, made changes and so
on,
> then, I want to create another user to this job, I have added a user
as
> member of wheel and assigned permissions in the current database
directory
> of MySQL and nothing happens...when I try to connect to the database
it give
> me an ERROR...
>
> _______________________________________________
> [EMAIL PROTECTED] mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
"[EMAIL PROTECTED]"
>

_______________________________________________
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to