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