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