CODE EXAMPLE FOR PHP

change native password in phpmyadmin

CREATE USER 'nativeuser'@'localhost'IDENTIFIED WITH mysql_native_password BY 'password';