To elaborate further you do need to create a user in MySQL (who is not the
same as a unix user) and he does need to have a password - you can't just
leave it blank.
In MySQL you should find some scripts like mysql_setpermission - or you can
edit the user table directly (in the database called "mysql").
You need to be careful with the access permissions - what actions can this
user do - and what machines can it access the database from. You ought to
set it to the minimum number of hosts possible - ie yourhostname in DNS and
perhaps localhost however there is some confusion about this because some
people have reported problems with 127.0.01 (localhost) actually coming
back as "localhost.localdomain" and thus access is denied.
You can use "%" to allow access from all machines but only do this behind a
firewall and don't do this for production systems.
This really ought to be a FAQ - however I suppose it already is on the
turbine mailing lists.
Go Jyve Go.
>On Mon, 14 Aug 2000, Daniel Pfuhl wrote:
> > after compiling Turbine and Jyve an installing it I changed the
> > configuration-files.
> > In TurbineRessource.properties I left
> >
> > database.default.username=
> > database.default.password=
> >
> > as you can see. Is this the right way or do I have to create
> > a default user?
> > If I try to access Jyve from the browser this message appears:
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Exception: java.lang.Error: Error in BasePeer.initTableSchema(Visitor):
> > General error: Access denied for user: '@localhost' to database 'jyve'
At 11:11 14/08/00 -0700, Greg Morris wrote:
>You need to set the database username/password in the
>TurbineResources.properties to a user that actually has permission to
>access your database. Yes, you may need to create a new user in your
>database for this purpose.
>
>--
>Greg Morris
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
