Manuel installation Error

Imran khan3 years ago

I have installed the traccar in Ubuntu 20.04 using this method: "https://www.youtube.com/watch?v=Qb-6CrK7RaI"
But my traccar web is not open.
Can someone help me solve my problems?

2021-10-06 12:53:27  INFO: HikariPool-1 - Starting...
2021-10-06 12:53:27  WARN: Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
2021-10-06 12:53:33 ERROR: HikariPool-1 - Exception during pool initialization. - Public Key Retrieval is not allowed - UnableToConnectException (... < DataManager:130 < *:89 < Context:290 < Main:120 < ...)
2021-10-06 12:53:33 ERROR: Main method error - Public Key Retrieval is not allowed - UnableToConnectException (... < DataManager:130 < *:89 < Context:290 < Main:120 < ...)
Imran khan3 years ago

And I've also installed it directly through the Digital Ocean Marketplace.
Where my web has been opened
But There I am getting error while creating database

USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root'; GRANT ALL ON *.* TO 'root'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; CREATE DATABASE traccar;"

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Anton Tananaev3 years ago

For the original error, the easiest option is to disable SSL for the database connection.

As for installation from marketplace, why do you need to run any commands there? It comes with everything pre-installed.

Imran khan3 years ago

ok Thank u so much. Another problem I have is that I can't access mysql database in any other software.
How do I give privileges to MySQL database?

Anton Tananaev3 years ago

That doesn't sound like a question about Traccar. Probably ask on MySQL related resources.