Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 7 Jul 2003 15:38:56 -0400
From:      "Ken Menzel" <kenm@icarz.com>
To:        "Xpression" <admin@atenas.cult.cu>, "FreeBSD-questions" <freebsd-questions@freebsd.org>
Subject:   Re: Users question...
Message-ID:  <11d601c344bf$6809a250$c4db7bd1@icarz.com>
References:  <005601c344b4$119e3990$0501a8c0@bloodlust>

next in thread | previous in thread | raw e-mail | index | archive | help
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 mysql@lists.mysql.com

Hope this helps
Ken
----- Original Message ----- 
From: "Xpression" <admin@atenas.cult.cu>
To: "FreeBSD-questions" <freebsd-questions@freebsd.org>
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...
>
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
"freebsd-questions-unsubscribe@freebsd.org"
>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?11d601c344bf$6809a250$c4db7bd1>