mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
22 lines
738 B
PHP
22 lines
738 B
PHP
source include/not_embedded.inc;
|
|
|
|
call mtr.add_suppression('failed to read private_key.pem: 2 "No such file or directory"');
|
|
|
|
if (`select count(*) = 0 from information_schema.plugins where plugin_name = 'caching_sha2_password'`)
|
|
{
|
|
--skip Needs caching_sha2_password plugin
|
|
}
|
|
|
|
show status like 'caching_sha2_password%';
|
|
|
|
create user test1@'%' identified via caching_sha2_password using PASSWORD('pwd');
|
|
create user test2@'%' identified via caching_sha2_password;
|
|
show grants for test2@'%';
|
|
|
|
create procedure checkme() sql security invoker
|
|
select user(), current_user(), variable_value > '' as 'have_ssl'
|
|
from information_schema.session_status
|
|
where variable_name='ssl_cipher';
|
|
|
|
grant execute on test.* to test1@'%', test2@'%';
|