cancel
Showing results for 
Search instead for 
Did you mean: 

Problems to connect with mysql

unknown-user
Champ on-the-rise
Champ on-the-rise
i can to connect directly to database alfresco on terminal linux:
# mysql -u alfresco alfresco -p [intro]
(enter the password = alfresco)
mysql>

But when start /opt/alfresco/alfresco.sh
i get this message in alfresco.log :

18:38:48,128 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot create PoolableConnectionFactory  create PoolableConnectionFactory ( Access denied for user 'alfresco'@'localhost.localdomain  (using password: YES))



the file repository.properties is :
# Database configuration

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql:///${db.name}
db.username=alfresco
db.password=alfresco

what is happend? the configuration is correct but it no connect to database mysql why?

help me.

thank you.
2 REPLIES 2

alexander
Champ in-the-making
Champ in-the-making
I found that it is trying to login as alfresco@localhost.localdomain, not as alfresco@localhost as mentioned on http://wiki.alfresco.com/wiki/Development_Environment page.

So just use mysql -u root -e "grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;" -p

Worked for me

unknown-user
Champ on-the-rise
Champ on-the-rise
You're right, thanks a lot…

Smiley Very Happy