MikeDre
1/20/2019 - 5:13 PM

MySQL Config / Local setup

https://stackoverflow.com/questions/43094726/your-password-does-not-satisfy-the-current-policy-requirements

SHOW VARIABLES LIKE 'validate_password%';

SET GLOBAL validate_password.length = 3; // Changing to dev

SET GLOBAL validate_password.number_count = 0;

https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0

CREATE USER 'dev'@'localhost' IDENTIFIED BY 'dev';

GRANT ALL PRIVILEGES ON *.* TO 'dev'@'%' WITH GRANT OPTION;


If you can't add user:

drop user admin@localhost;
flush privileges;
create user admin@localhost identified by 'admins_password'


If phpmyadmin gives this error:

The server requested authentication method unknown to the client [caching_sha2_password]

alter user 'dev'@'localhost' identified with mysql_native_password by 'dev';