Skip to content

Testing

Jump to bottom
Inada Naoki edited this page Jul 1, 2023 · 8 revisions

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 )

Clone this wiki locally