Testing (original) (raw)

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.

If you set up MySQL without Docker, set local-infile server setting.

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 )