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]"