mysql configuration

Nelson Loyola edited this page Oct 15, 2018 · 3 revisions

Wiki ▸ Server Installation ▸ MySQL Configuration

MySQL server configuration for Biobank

Stop the mysql server if it is already running:
```
sudo service mysql stop
```
MySQL requires the following setting in /etc/mysql/mysql.conf.d/mysqld.cnf: In section [mysqld] the following line should be added:
```
lower_case_table_names=1
sql_mode=NO_ENGINE_SUBSTITUTION
```
Remove the old server log files /var/lib/mysql/ib_logfile0 and /var/lib/mysql/ib_logfile1.
Start the mysql server:
```
sudo service mysql start
```

If the MySQL server doesn't start, you can see the errors of your mysql server in /var/log/mysql/error.log.