equal
deleted
inserted
replaced
1 ================================================================================ |
1 ================================================================================ |
2 ================================ Install mysql ================================= |
2 ================================ Install mysql ================================= |
3 ================================================================================ |
3 ================================================================================ |
4 |
4 |
5 $ pkg install database/mysql-56 database/mysql-56/client |
5 $ pkg install database/mysql-57 database/mysql-57/client |
6 |
6 |
7 |
7 |
8 |
8 |
9 ================================================================================ |
9 ================================================================================ |
10 ========================== Init database & run daemon ========================== |
10 ========================== Init database & run daemon ========================== |
13 #!/bin/bash |
13 #!/bin/bash |
14 |
14 |
15 set -x |
15 set -x |
16 |
16 |
17 MYSQL_TEST_DATADIR=/var/tmp/mysql |
17 MYSQL_TEST_DATADIR=/var/tmp/mysql |
18 MYSQL_VERSION=5.6 |
18 MYSQL_VERSION=5.7 |
19 MYSQL_BINDIR=/usr/mysql/$MYSQL_VERSION/bin |
19 MYSQL_BINDIR=/usr/mysql/$MYSQL_VERSION/bin |
20 MYSQL_TEST_USER=root |
20 MYSQL_TEST_USER=root |
21 MYSQL_TEST_PASSWORD=new-password |
21 MYSQL_TEST_PASSWORD=new-password |
22 |
22 |
23 rm -rf "$MYSQL_TEST_DATADIR" |
23 rm -rf "$MYSQL_TEST_DATADIR" |
24 |
24 |
25 "$MYSQL_BINDIR/mysql_install_db" \ |
25 "$MYSQL_BINDIR/mysqld" \ |
26 --keep-my-cnf \ |
26 --initialize-insecure \ |
27 --datadir="$MYSQL_TEST_DATADIR" \ |
27 --datadir="$MYSQL_TEST_DATADIR" \ |
28 --basedir=/usr/mysql/$MYSQL_VERSION |
28 --basedir=/usr/mysql/$MYSQL_VERSION |
29 |
29 |
30 # Run the daemon in background. |
30 # Run the daemon in background. |
31 # --gdb makes it possible to terminate mysqld via Ctrl+C |
31 # --gdb makes it possible to terminate mysqld via Ctrl+C |
32 "$MYSQL_BINDIR/mysqld" \ |
32 "$MYSQL_BINDIR/mysqld" \ |
33 --skip-networking \ |
33 --skip-networking \ |
34 -u $MYSQL_TEST_USER \ |
34 -u "$MYSQL_TEST_USER" \ |
35 --datadir="$MYSQL_TEST_DATADIR" \ |
35 --datadir="$MYSQL_TEST_DATADIR" \ |
36 --socket="$MYSQL_TEST_DATADIR"/socket \ |
36 --socket="$MYSQL_TEST_DATADIR"/socket \ |
37 --pid-file="$MYSQL_TEST_DATADIR"/pid \ |
37 --pid-file="$MYSQL_TEST_DATADIR"/pid \ |
38 --gdb & |
38 --gdb & |
39 |
39 |
42 "$MYSQL_BINDIR/mysqladmin" \ |
42 "$MYSQL_BINDIR/mysqladmin" \ |
43 --socket "$MYSQL_TEST_DATADIR"/socket \ |
43 --socket "$MYSQL_TEST_DATADIR"/socket \ |
44 -u "$MYSQL_TEST_USER" \ |
44 -u "$MYSQL_TEST_USER" \ |
45 password "$MYSQL_TEST_PASSWORD" |
45 password "$MYSQL_TEST_PASSWORD" |
46 |
46 |
|
47 "$MYSQL_BINDIR/mysqladmin" \ |
|
48 --socket "$MYSQL_TEST_DATADIR"/socket \ |
|
49 -u "$MYSQL_TEST_USER" \ |
|
50 --password="$MYSQL_TEST_PASSWORD" \ |
|
51 create test |
47 |
52 |
48 |
53 |
49 ================================================================================ |
54 ================================================================================ |
50 ============ In perl craete DB, table, trigger and insert some data ============ |
55 ============ In perl craete DB, table, trigger and insert some data ============ |
51 ================================================================================ |
56 ================================================================================ |