mysql install/config kicking my butt

Justin Bleich April 6, 2020

I have mysql server installed on my windows box but after the config which is step 2 in this article https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html the mysql80 service will not restart...

I tried everything suggested in here https://stackoverflow.com/questions/35670755/the-mysql-service-on-local-computer-started-and-then-stopped

 

And i am still getting the same error on trying to start it back up. I make copies of my.ini and will re-load the original and it works, but i have tried notepad, wordpad and notepad++ to do the configuration changes and every time i save and try to restart get that same error.

1 answer

0 votes
Mathias_V__Nielsen April 6, 2020

Hi Justin,

That sounds like a configuration error.
I think it would be easier to help if we could get a look at your config that is failing. (hastebin etc..)

Justin Bleich April 6, 2020

In the my.ini file under [mysqld] i added the following

 

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_bin
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB
transaction-isolation=READ-COMMITTED
binlog_format=low

Suggest an answer

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

Atlassian Community Events