| 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 : |
# We don't care about innodb warnings at this point
CALL mtr.add_suppression("InnoDB:");
# shut server down
# Server is down
#
# Bug #20546898: MYSQLD --INIT-FILE DOESN\'T ACCEPT GRANT STATEMENTS
#
# create bootstrap file with ACL commands
# Run the server with --initialize --init-file
extract the root password
password found
# Restart the server against DDIR
# connect as root
# reset the password
SET PASSWORD='';
# Must have USAGE
SHOW GRANTS FOR u1@localhost;
Grants for u1@localhost
GRANT USAGE ON *.* TO 'u1'@'localhost'
# Must have a SELECT privilege
SHOW GRANTS FOR u3@localhost;
Grants for u3@localhost
GRANT SELECT ON `grants_try`.* TO 'u3'@'localhost'
GRANT USAGE ON *.* TO 'u3'@'localhost'
# Must have a password
SHOW CREATE USER u2@localhost;
CREATE USER for u2@localhost
CREATE USER 'u2'@'localhost' IDENTIFIED WITH 'mysql_native_password' AS '*85D0F19E5598AC04AC7B3FCF5383247D28FB59EF' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK
# shut server down
# Server is down
# close the test connection
# remove the password file
# delete mysqld log
# delete bootstrap file
# delete datadir
#
# Cleanup
#
# Restarting the server