| Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/r/ |
Upload File : |
# Basic cases related to mysql_install_db # Execute m_i_db without any options where the file MYSQL_TMP_DIR/.mysql_secret is not there. Start server and try to login with root credentials. # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; select count(*) from mysql.user; count(*) 4 # Execute m_i_db without any options where MYSQL_TMP_DIR/.mysql_secret is there. Start server and try to login with root credentials. # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # with --insecure where the file MYSQL_TMP_DIR/.mysql_secret is not there. Start server and try to login with root credentials # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-user # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password test_user localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password test_user localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --login-path when passed with --login-file # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password test_user2 localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior when login-path is not passed, but only --login-file # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password test_user2 localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-user # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password test_user localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Now without the option --insecure # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password test_user localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-host # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root 127.0.0.1 mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root 127.0.0.1 mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-host when passed along with --admin-path # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-require-ssl when no value is passed with the option # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. ERROR 28000: Access denied for user 'root'@'localhost' (using password: NO) SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-require-ssl when ON is passed with the option # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. ERROR 28000: Access denied for user 'root'@'localhost' (using password: YES) SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. ERROR 28000: Access denied for user 'root'@'localhost' (using password: NO) SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-require-ssl when OFF is passed with the option # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Check the behavior of the option --admin-require-ssl when invalid value is passed with the option # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Invoke mysql_install_db with --random-password-file=<valid path of file> where the file at specified path does not exist # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Below case is, when --random-password-file already exists # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user FROM mysql.user; ERROR HY000: You must reset your password using ALTER USER statement before executing this statement. set password='abc'; SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Execution of mysql_install_db starts............ # Execution of mysql_install_db ends.............. SELECT user,host,plugin FROM mysql.user WHERE password_expired='n' ORDER BY user; user host plugin mysql.session localhost mysql_native_password mysql.sys localhost mysql_native_password root localhost mysql_native_password SELECT count(*) FROM mysql.user; count(*) 3 CREATE USER 'u1'@'localhost'; GRANT ALL ON *.* TO 'u1'@'localhost'; show databases; Database information_schema mtr mysql performance_schema sys test set password=''; # Reset mtr state "execution finished............