After MySQL databese setup I get connection error

Matti Kiviharju
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 15, 2023

Screenshot 2023-10-15 235114.png

What to do?

On previous step database connection success.

And when I write this to hostname: localhost?transaction-isolation=READ-COMMITTED

Then I get this error below:

Screenshot 2023-10-16 151454.png

I have MySQL 8.0 and here is it's conf:

[mysqld]
#
# * Basic Settings
#
user = mysql
# pid-file = /var/run/mysqld/mysqld.pid
# socket = /var/run/mysqld/mysqld.sock
# port = 3306
# datadir = /var/lib/mysql
transaction-isolation=READ-COMMITTED
character-set-server=utf8mb4
collation-server=utf8mb4_bin
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB
sql_mode = NO_AUTO_VALUE_ON_ZERO
binlog_format=row
log_bin_trust_function_creators = 1
#optimizer_switch = derived_merge=off

1 answer

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 16, 2023

Hi @Matti Kiviharju ,

it seems that confluence db user has not enough privileges on the db. Please could you check user privileges on mysql side?

Fabio

Matti Kiviharju
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2023

Yes I have all privileges on the db.

Screenshot 2023-10-16 183035.png

Matti Kiviharju
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 16, 2023

I need to get my Confluence Data Center version to work ASAP, because I have a big client for my Timesheet for Confluence Server App and they wants now Data center version. They orders a 500 users license and that makes a big money for my company named i4ware Software. My client is been very happy with my Timesheet App and are used it about 3 years now.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.6.0
TAGS
AUG Leaders

Atlassian Community Events