mysql: create local user and remote user

 

CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypass’;
GRANT ALL ON *.* TO ‘myuser’@’localhost’;

 

CREATE USER ‘myuser’@’%’ IDENTIFIED BY ‘mypass
GRANT ALL ON *.* TO ‘myuser’@’%’;

 

flush privileges;

Leave a Reply

Your email address will not be published.