| Server IP : 172.67.216.182 / Your IP : 104.23.175.138 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 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 : ON Directory : /www/server/mysql/src/mysql-test/suite/auth_sec/r/ |
Upload File : |
# Check with mysql_native_password as --default-authentication-plugin # Restart the server with mysql_native_password as default authnetication plugin # Create users CREATE USER qa_test_1_user IDENTIFIED WITH qa_auth_interface AS 'qa_test_1_dest'; CREATE USER qa_test_1_dest IDENTIFIED BY 'dest_passwd'; GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_1_dest identified by 'dest_passwd'; Warnings: Warning 1287 Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation. GRANT PROXY ON qa_test_1_dest TO qa_test_1_user; CREATE USER native@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd'; CREATE USER sha256@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd'; # Connection tests mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() native@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() native@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() native@localhost FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() sha256@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() sha256@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() sha256@localhost FLUSH PRIVILEGES; # Change user tests SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() qa_test_1_user@% SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() qa_test_1_user@% SELECT CURRENT_USER(); CURRENT_USER() qa_test_1_user@% # Drop users DROP USER qa_test_1_user; DROP USER qa_test_1_dest; DROP USER native@localhost; DROP USER sha256@localhost; # Check with sha256_password as --default-authentication-plugin # Restart the server with sha256_password as default authnetication plugin # Create users CREATE USER qa_test_1_user IDENTIFIED WITH qa_auth_interface AS 'qa_test_1_dest'; CREATE USER qa_test_1_dest IDENTIFIED BY 'dest_passwd'; GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_1_dest identified by 'dest_passwd'; Warnings: Warning 1287 Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation. GRANT PROXY ON qa_test_1_dest TO qa_test_1_user; CREATE USER native@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd'; CREATE USER sha256@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd'; # Connection tests mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() qa_test_1_user@% FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() native@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() native@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() native@localhost FLUSH PRIVILEGES; mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() sha256@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() sha256@localhost mysql: [Warning] Using a password on the command line interface can be insecure. CURRENT_USER() sha256@localhost FLUSH PRIVILEGES; # Change user tests SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() qa_test_1_user@% SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() sha256@localhost SELECT CURRENT_USER(); CURRENT_USER() qa_test_1_user@% SELECT CURRENT_USER(); CURRENT_USER() qa_test_1_user@% # Drop users DROP USER qa_test_1_user; DROP USER qa_test_1_dest; DROP USER native@localhost; DROP USER sha256@localhost;