WikiSysop: Новая страница: « decrease security SET GLOBAL validate_password_length=4; SET GLOBAL validate_password_policy=LOW; update user password UPDATE mysql.user SET authenticatio…»

2018-07-08T03:09:02Z

Новая страница: « decrease security SET GLOBAL validate_password_length=4; SET GLOBAL validate_password_policy=LOW; update user password UPDATE mysql.user SET authenticatio…»

Нова сторінка

decrease security

SET GLOBAL validate_password_length=4;
SET GLOBAL validate_password_policy=LOW;

update user password
UPDATE mysql.user SET authentication_string = PASSWORD('pass'), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost';

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED WITH mysql_native_password by 'pass';

grant option privilege
GRANT GRANT OPTION ON *.* TO 'user'@'%';

replace wrong datetime in data file

for all
sed -i -- 's/0000-00-00/2018-01-01/g' *.data

for one
sed -i -- 's/0000-00-00/2018-01-01/g' save_file.data

Mysql-tips - Історія редагувань

WikiSysop: Новая страница: « decrease security SET GLOBAL validate_password_length=4; SET GLOBAL validate_password_policy=LOW; update user password UPDATE mysql.user SET authenticatio…»