Gecko [ www.jdcpatala.org ]

Name	Size	Permission
access_credential_control.resu...	23.21 KB	-rw-r--r--
cert_verify.result	304 B	-rw-r--r--
early_plugin_load.result	789 B	-rw-r--r--
have_mysql_upgrade.result	21 B	-rw-r--r--
have_ssl.require	33 B	-rw-r--r--
install_keyring.result	263 B	-rw-r--r--
install_keyring_file.result	979 B	-rw-r--r--
key_rotation.result	427 B	-rw-r--r--
key_rotation_qa.result	7.57 KB	-rw-r--r--
key_value_auth.result	13 KB	-rw-r--r--
keyring_file.result	479 B	-rw-r--r--
keyring_file_data.result	1.17 KB	-rw-r--r--
keyring_file_data_qa.result	2.66 KB	-rw-r--r--
keyring_udf.result	29.95 KB	-rw-r--r--
multiple_plugins.result	5.46 KB	-rw-r--r--
mysql_native_plugin.result	10.46 KB	-rw-r--r--
mysql_no_login.result	2.03 KB	-rw-r--r--
mysql_protocol_types.result	2.38 KB	-rw-r--r--
mysql_protocol_types_windows.r...	1.93 KB	-rw-r--r--
mysql_sha256_plugin.result	9.84 KB	-rw-r--r--
mysql_ssl_connection.result	202 B	-rw-r--r--
mysql_ssl_rsa_setup.result	1.4 KB	-rw-r--r--
named_pipe_ssl.result	255 B	-rw-r--r--
not_embedded.require	16 B	-rw-r--r--
not_openssl.require	36 B	-rw-r--r--
not_ssl.require	32 B	-rw-r--r--
openssl.require	37 B	-rw-r--r--
openssl_cert_generation.result	7.37 KB	-rw-r--r--
openssl_cert_generation_debug....	577 B	-rw-r--r--
openssl_cert_generation_subjec...	435 B	-rw-r--r--
openssl_cert_validity.result	109 B	-rw-r--r--
openssl_skip_cert_generation.r...	442 B	-rw-r--r--
password_expired.result	16.4 KB	-rw-r--r--
password_expiry.result	8.09 KB	-rw-r--r--
require_secure_transport.resul...	1.49 KB	-rw-r--r--
require_secure_transport_windo...	2.08 KB	-rw-r--r--
secure_file_priv_error.result	358 B	-rw-r--r--
secure_file_priv_null.result	1.08 KB	-rw-r--r--
secure_file_priv_warnings.resu...	876 B	-rw-r--r--
secure_file_priv_warnings_not_...	582 B	-rw-r--r--
secure_file_priv_warnings_win....	454 B	-rw-r--r--
server_withssl_client_withouts...	6.18 KB	-rw-r--r--
server_withssl_client_withssl....	6.08 KB	-rw-r--r--
set_password_deprecated.result	4.76 KB	-rw-r--r--
ssl_auto_detect.result	1.82 KB	-rw-r--r--
ssl_auto_detect_openssl.result	361 B	-rw-r--r--
ssl_mode.result	5.16 KB	-rw-r--r--
tls.result	1.25 KB	-rw-r--r--
tls12_tls1.result	510 B	-rw-r--r--
wrong_keyring_file.result	166 B	-rw-r--r--
wrong_keyring_file_data.result	731 B	-rw-r--r--

Code Editor : multiple_plugins.result

# 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;

${this.title}

Code Editor : multiple_plugins.result