CREATE DATABASE traccar CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'traccar'@'localhost' IDENTIFIED BY 'e5%28ejhvlskcs*636dhdjds';
GRANT ALL PRIVILEGES ON traccardb.* TO 'traccar'@'localhost'; IDENTIFIED BY 'e5%28ejhvlskcs*636dhdjds' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
systemctl start traccar.service
<entry key='database.driver'>com.mysql.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost/traccar?serverTimezone=UTC&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8 amp;sessionVariables=sql_mode=''</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>e5%28ejhvlskcs*636dhdjds</entry>
<entry key='database.driver'>com.mysql.cj.jdbc.Driver</entry>
<entry key='database.url'>jdbc:mysql://localhost/traccar?zeroDateTimeBehavior=round&serverTimezone=UTC&allowPublicKeyRetrieval=true&useSSL=false&allowMultiQueries=true&autoReconnect=true&useUnicode=yes&characterEncoding=UTF-8&sessionVariables=sql_mode=''</entry>
<entry key='database.user'>traccar</entry>
<entry key='database.password'>e5%28ejhvlskcs*636dhdjds</entry>
CREATE DATABASE traccardb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;