View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000661 | SymmetricDS | Task | public | 2012-06-21 21:53 | 2012-06-22 15:55 |
| Reporter | Smitabk | Assigned To | chenson | ||
| Priority | normal | ||||
| Status | closed | Resolution | no change required | ||
| Product Version | 2.5.13 | ||||
| Summary | 0000661: Access denied for user symmetric @localhost | ||||
| Description | While 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. | ||||
| Tags | No tags attached. | ||||
|
|
Can you post your properties file? |
|
|
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 |
|
|
Can you connect to the database as symmetric/secret using other tools? This is a database user configuration issue, not a symmetricds issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-06-21 21:53 | Smitabk | New Issue | |
| 2012-06-22 15:05 | chenson | Note Added: 0000013 | |
| 2012-06-22 15:21 | Smitabk | Note Added: 0000014 | |
| 2012-06-22 15:54 | chenson | Note Added: 0000015 | |
| 2012-06-22 15:55 | chenson | Status | new => closed |
| 2012-06-22 15:55 | chenson | Assigned To | => chenson |
| 2012-06-22 15:55 | chenson | Resolution | open => no change required |