Setting innodb values in my.cnf Ubuntu 18.04

Question

Installing JPS onto an Ubuntu 18.04 VM.

I have found /etc/mysql/mysql.cnf but it only contains two include lines.

I added

innodb_buffer_pool_size=5500Minnodb_file_per_table=1

At the point mysql refused to start. Removing the lines allowed it to start again.

Suggestions?

ryan_ball · Accepted Answer

@honestpuck The file you want is /etc/mysql/mysql.conf.d/mysqld.cnf on 18.04.
Remove it from what you used initially and add it there.

I commented about this in the following article:
https://www.jamf.com/jamf-nation/articles/542/creating-the-jamf-pro-database
Jamf should update the article or at least note this.

kerouak · Answer

are you sure that's the correct file??I use RedHat and my file is located at /etc/my.cnfpossibly try searching for my.cnf as opposed to mysql.cnf?

Sign up