Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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 edited

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 Champion
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
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events