usuario remoto

Usuario remoto MySQL

[mysqld]
default-authentication-plugin=mysql_native_password
default_authentication_plugin=sha256_password


CREATE USER ‘remotobd’@’%’ IDENTIFIED WITH sha256_password BY ‘pass#23’;
ALTER USER ‘remotobd’@’%’ IDENTIFIED WITH mysql_native_password BY ‘pass#23’;
— todos los privilagios al usuario
GRANT ALL PRIVILEGES ON . TO ‘remotobd’@’%’;
FLUSH PRIVILEGES;

Leave a Reply

Your email address will not be published. Required fields are marked *