ubuntu mysql remote access code example

Example 1: mysql remote acces ubuntu

GRANT ALL ON wordpressdb.* TO 'wpadmin'@'192.168.1.100' IDENTIFIED BY '%u#098Tl3' WITH GRANT OPTION;

Example 2: digitalocean mysql connect remote

RENAME USER 'sammy'@'localhost' TO 'sammy'@'remote_server_ip';