November 19

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;


Copyright 2021. All rights reserved.

Posted November 19, 2021 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B