Testing

Use Docker to run MySQL for testing

docker run -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -e MYSQL_DATABASE=gotest -p 3306:3306 \
    --rm --name mysqld mysql:latest --innodb-flush-log-at-trx-commit=0 --local-infile=1

• --innodb-flush-log-at-trx-commit=0: Do not wait disk at commit. This option is just for performance.
• --local-infile=1: Enable LOAD LOCAL INFILE query.

Parameters for test

Maybe you need to edit the parameters the connection to the sever is opened with. Here is an example how you can set a different password:

Linux / Unix based

$ export MYSQL_TEST_PASS=root

Windows

$ SET MYSQL_TEST_PASS=root

Parameter List

• MYSQL_TEST_USER ( User )
• MYSQL_TEST_PASS ( Password )
• MYSQL_TEST_PROT ( Network Protocol )
• MYSQL_TEST_ADDR ( Network Adress )
• MYSQL_TEST_DBNAME ( Database name)
• MYSQL_TEST_CONCURRENT ( 1 = enable ConcurrentTest )