1
2# Embedded server doesn't support external clients
3--source include/not_embedded.inc
4#
5# Test "mysqladmin ping"
6#
7
8--exec $MYSQLADMIN --no-defaults --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT  -u root --password= ping 2>&1
9
10
11#
12# Bug#10608 mysqladmin breaks on "database" variable in my.cnf
13#
14
15# When mysqladmin finds database in .cnf file it shall fail
16--write_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf
17[client]
18database=db1
19EOF
20
21--replace_regex /.*mysqladmin.*: unknown/mysqladmin: unknown/
22--error 7
23--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/bug10608.cnf --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT  -u root --password= ping 2>&1
24remove_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf;
25
26# When mysqladmin finds "loose-database" in .cnf file it shall print
27# a warning and continue
28--write_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf
29[client]
30loose-database=db2
31EOF
32
33--replace_regex /Warning: .*mysqladmin.*: unknown/Warning: mysqladmin: unknown/
34--exec $MYSQLADMIN --defaults-file=$MYSQLTEST_VARDIR/tmp/bug10608.cnf --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT  -u root --password= ping 2>&1
35
36remove_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf;
37
38#
39# WL#3126 TCP address binding for mysql client library;
40# - running mysqladmin --protcol=tcp --bind-address=127.0.0.1
41#
42--exec $MYSQLADMIN --no-defaults --protocol=tcp --bind-address=127.0.0.1 --host=127.0.0.1 -P $MASTER_MYPORT -u root ping 2>&1
43--echo #
44--echo # Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
45--echo #
46
47--echo # Executing mysqladmin with --sleep=1 and --count=2.
48--exec $MYSQLADMIN --no-defaults -u root -S $MASTER_MYSOCK -P $MASTER_MYPORT --sleep=1 --count=2 ping > $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
49--echo # Done.
50--echo # Displaying the output :
51--cat_file $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
52
53--remove_file $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
54
55--echo #
56--echo # BUG#11766184 - 59234: cmdline clients crash --defaults-extra-file
57--echo #                with no .cnf or .ini extension.
58--echo #
59
60--echo # Creating an empty file 'cnf_file'
61--write_file $MYSQLTEST_VARDIR/tmp/cnf_file
62EOF
63
64--echo # Using --defaults-extra-file option with 'cnf_file'.
65--exec $MYSQLADMIN --defaults-extra-file=$MYSQLTEST_VARDIR/tmp/cnf_file -uroot -h localhost --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
66
67--remove_file $MYSQLTEST_VARDIR/tmp/cnf_file
68
69--echo #
70--echo # Bug#12688860 : SECURITY RECOMMENDATION: PASSWORDS ON CLI
71--echo #
72
73--exec $MYSQLADMIN --no-defaults -uroot --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
74
75
76--echo #
77--echo # Bug#21796658: OLD-PASSWORD SUBCOMMAND IS STILL IN MYSQLADMIN --HELP IN 5.7
78--echo #
79
80--let $admin_outfile=$MYSQLTEST_VARDIR/tmp/bug21796658.output
81
82--echo # execute mysqladmin --help
83# Returns 1 on normal execution
84--error 1
85--exec $MYSQLADMIN --help 2>&1 > $admin_outfile
86
87--echo # check the output of mysqladmin for old-password
88--let $assert_text= check the output of mysqladmin for old-password
89--let $assert_file= $admin_outfile
90--let $assert_select=old-password
91--let $assert_count=0
92--source include/assert_grep.inc
93
94--echo # cleanup
95--remove_file $admin_outfile
96
97
98--echo End of tests
99