Re: Cannot install jahia 5.0 on mysql 5.0

Sanjay Goel wrote:

> Hi,
> I have been trying to use mysql as a backend db for jahia. In Jahia 
> Configuration wizard, I go to advance settings for database, select 
> mysql and put these values
> driver com.mysql.jdbc.Driver
> url jdbc:mysql://localhost/jahia?useUnicode=true&characterEncoding=UTF-8
> username jahia
> passwd jahia
>
> I have already created a user jahia with passwd jahia and also created 
> the database jahia on my local mysql server. I also have UTF-8 charset 
> enabled in my mysql server instance. I am able to connect to this DB 
> using mysql client.
> However, when I use these settings, jahia gives an error - Can't talk 
> with the database. Check your settings.
>
> I also tried url 
> jdbc:mysql://localhost:3306/jahia?useUnicode=true&characterEncoding=UTF-8
>
> What can be possibly wrong in this setup?
> Sanjay Goel
> http://sanjaygoel.blogspot.com 

Have you given all privileges to your database for the given username 
and password like this:

Grant all privileges on jahia to 'jahia'@'localhost';
Flush privileges;

I had a similar problem and eventually it solved itself with the above 
MySQL commands and the code you mentioned.
Oh and thanks for putting your improved readme file up as it helped me a 
lot to get Jahia 5 built and deployed.

Hope this helps,

Dan

-- 
Dan O'Hare
Developer

SOUK Digital
A SOUK Group Company.

http://www.soukdigital.com/

Nottingham Office
High Pavement Business Centre,
3-5 High Pavement,
The Lace Market,
Nottingham.
NG1 1HF
Tel: +44 (0) 115 959 6455
Fax: +44 (0) 115 959 6456
Direct: +44 (0) 115 959 6472

London Office
1st Floor,
Shaftesbury House,
151 Shaftesbury Avenue,
London WC2H 8AL
Tel: +44 (0) 20 7420 7880

Confidentiality: This e-mail and its attachments are intended for
the above named only and may be confidential. If they have come
to you in error you must take no action based on them, nor must
you copy or show them to anyone; please reply to this e-mail and
highlight the error.

Security Warning: Please note that this e-mail has been created
in the knowledge that Internet e-mail is not a 100% secure
communications medium. We advise that you understand and observe
this lack of security when e-mailing us.

Viruses: Although we have taken steps to ensure that this e-mail
and attachments are free from any virus, we advise that in keeping
with good computing practice the recipient should ensure they are
actually virus free.