View Issue Details

IDProjectCategoryView StatusLast Update
0000661SymmetricDSTaskpublic2012-06-22 11:55
ReporterSmitabkAssigned Tochenson 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Product Version2.5.13 
Target VersionFixed in Version 
Summary0000661: Access denied for user symmetric @localhost
DescriptionWhile installing symmetricds in mysystem im getting Access denied for user symmetric @localhost(password= yes) error, tried all options using internet, but no use i cudnt install or connect.
TagsNo tags attached.

Activities

chenson

2012-06-22 11:05

administrator   ~0000013

Can you post your properties file?

Smitabk

2012-06-22 11:21

reporter   ~0000014

Sure
ROOT FILE:
# The class name for the JDBC Driver
db.driver=com.mysql.jdbc.Driver


# The JDBC URL used to connect to the database
db.url=jdbc:mysql://localhost\\sample

Grants for @localhost

GRANT USAGE ON *.* TO ''@'localhost'


# The user to login as who can create and update tables
db.user=symmetric

# The password for the user to login as
db.password=secret

registration.url=http://localhost:8080/sync
sync.url=http://localhost:8080/sync

# Do not change these for running the demo
group.id=corp
external.id=00000

# Don't muddy the waters with purge logging
job.purge.period.time.ms=7200000


CLIENT FILE:
# The class name for the JDBC Driver
db.driver=com.mysql.jdbc.Driver


# The JDBC URL used to connect to the database
db.url=jdbc:mysql://localhost\\sample

# The user to login as who can create and update tables
db.user=symmetric

# The password for the user to login as
db.password=secret

# The HTTP URL of the root node to contact for registration
registration.url=http://localhost:8080/sync

# Do not change these for running the demo
group.id=store
external.id=1

job.routing.period.time.ms=2000

# This is how often the push job will be run.
job.push.period.time.ms=5000

# This is how often the pull job will be run.
job.pull.period.time.ms=5000

chenson

2012-06-22 11:54

administrator   ~0000015

Can you connect to the database as symmetric/secret using other tools? This is a database user configuration issue, not a symmetricds issue.

Issue History

Date Modified Username Field Change
2012-06-21 17:53 Smitabk New Issue
2012-06-22 11:05 chenson Note Added: 0000013
2012-06-22 11:21 Smitabk Note Added: 0000014
2012-06-22 11:54 chenson Note Added: 0000015
2012-06-22 11:55 chenson Status new => closed
2012-06-22 11:55 chenson Assigned To => chenson
2012-06-22 11:55 chenson Resolution open => no change required