1# Embedded server doesn't support external clients
2--source include/not_embedded.inc
3#
4# Test "mysqladmin ping"
5#
6
7--exec $MYSQLADMIN --no-defaults --default-character-set=latin1 -S $MASTER_MYSOCK -P $MASTER_MYPORT  -u root --password= ping 2>&1
8
9
10#
11# Bug#10608 mysqladmin breaks on "database" variable in my.cnf
12#
13
14# When mysqladmin finds database in .cnf file it shall fail
15--write_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf
16[client]
17database=db1
18EOF
19
20--replace_regex /.*mysqladmin.*: unknown/mysqladmin: unknown/
21--error 7
22--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
23remove_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf;
24
25# When mysqladmin finds "loose-database" in .cnf file it shall print
26# a warning and continue
27--write_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf
28[client]
29loose-database=db2
30EOF
31
32--replace_regex /Warning: .*mysqladmin.*: unknown/Warning: mysqladmin: unknown/
33--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
34
35remove_file $MYSQLTEST_VARDIR/tmp/bug10608.cnf;
36
37#
38# WL#3126 TCP address binding for mysql client library;
39# - running mysqladmin --protcol=tcp --bind-address=127.0.0.1
40#
41--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
42--echo #
43--echo # Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
44--echo #
45
46--echo # Executing mysqladmin with --sleep=1 and --count=2.
47--exec $MYSQLADMIN -u root -S $MASTER_MYSOCK -P $MASTER_MYPORT --sleep=1 --count=2 ping > $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
48--echo # Done.
49--echo # Displaying the output :
50--cat_file $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
51
52--remove_file $MYSQLTEST_VARDIR/tmp/mysqladmin.tmp
53
54--echo #
55--echo # BUG#11766184 - 59234: cmdline clients crash --defaults-extra-file
56--echo #                with no .cnf or .ini extension.
57--echo #
58
59--echo # Creating an empty file 'cnf_file'
60--write_file $MYSQLTEST_VARDIR/tmp/cnf_file
61EOF
62
63--echo # Using --defaults-extra-file option with 'cnf_file'.
64--exec $MYSQLADMIN --defaults-extra-file=$MYSQLTEST_VARDIR/tmp/cnf_file -uroot -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
65
66--remove_file $MYSQLTEST_VARDIR/tmp/cnf_file
67
68--echo #
69--echo # Bug#12688860 : SECURITY RECOMMENDATION: PASSWORDS ON CLI
70--echo #
71
72--exec $MYSQLADMIN -uroot --password="" -S $MASTER_MYSOCK -P $MASTER_MYPORT ping 2>&1
73
74--echo
75--echo End of tests
76