AnonSec Shell
Server IP : 185.86.78.101  /  Your IP : 216.73.216.124
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/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /www/server/mysql/mysql-test/t/mysql_upgrade_ssl.test
# mysql_upgrade tests requiring SSL support

-- source include/have_ssl_communication.inc
-- source include/mysql_upgrade_preparation.inc

--echo #
--echo # Bug#55672 mysql_upgrade dies with internal error 
--echo #
--exec $MYSQL_UPGRADE --skip-verbose --ssl-mode=REQUIRED --force 2>&1

--echo #
--echo # WL #8350 ENSURE 5.7 SUPPORTS SMOOTH LIVE UPGRADE FROM 5.6
--echo #

# Backup mysql.user table
DROP TABLE IF EXISTS tmp_user;
CREATE TEMPORARY TABLE tmp_user AS (SELECT * FROM mysql.user);

# Create 5.6 mysql.user table layout

--source include/user_57_to_56.inc

--echo # "Manualy" create user with sha256 password
INSERT INTO mysql.user VALUES 
('%','user_sha_pass_wp','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'sha256_password','$5$J=M`}N+i=%1o6z\'$Ns0lpHRzOCs9T4n5df6ZxAYsUaK1yFMnRGlp3T48AW/','N');

FLUSH PRIVILEGES;

--echo #"Manualy grant" super user privileges to user_sha_pass_wp
UPDATE mysql.user SET Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y', Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y', Create_tablespace_priv='Y' where user="user_sha_pass_wp";

FLUSH PRIVILEGES;

--echo #Run mysql_upgrade with user_sha_pass_wp -n i.e. user with sha256
--echo #password set. After mysql_upgrade finishes the mysql.user table should
--echo #have 5.7 layout thus no need to restore the dropped columns from
--echo #the begining of the test
--exec $MYSQL_UPGRADE --skip-verbose --force --ssl-mode=REQUIRED --user=user_sha_pass_wp --password=lala 2>&1

DROP USER 'user_sha_pass_wp'@'%';
#
# Restore mysql.user content
TRUNCATE TABLE mysql.user;
INSERT INTO mysql.user SELECT * FROM tmp_user;
DROP TABLE tmp_user;

--source include/mysql_upgrade_cleanup.inc

Anon7 - 2022
AnonSec Team