Mysql常用SQL

CREATE DATABASE IF NOT EXISTS xinda_test DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

CREATE USER 'xinda'@'%' IDENTIFIED BY 'xinda';
grant all privileges on xinda_test.* to 'xinda'@'%' with grant option;
flush privileges;

CREATE TABLE test
(
id int(11) NOT NULL,
PRIMARY KEY (id)
) DEFAULT CHARSET = utf8;

show variables like '%validate_password.policy%';
show variables like '%validate_password.length%';

set global validate_password.policy=0;  #设置为弱口令
set global validate_password.length=1;  #密码最小长度为1

show variables like '%validate_password_policy%';
show variables like '%validate_password_length%';

set global validate_password_policy=0;
set global validate_password_length=1;