☰ Categories

MySQL: update a remote user connection

mysql -u root -p
SELECT User, Host FROM mysql.user;
UPDATE mysql.user SET host = ‘newservername.domainname.com or ip’ where host = ‘originalservername.domainname.com or ip’ AND user = ‘root’;
flush privileges;