How to alter user host in MySQL? asked Aug 3 in DBMS by Pantycle_Genefanty (10.9k points) 0 like 0 dislike 18 views How I can to change host of user in DBMS MySQL? mysql alter user host how to change user host in mysql mysql sql db user host dbms change alter Your comment on this question: Your name to display (optional): Email me at this address if a comment is added after mine:Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications. Anti-spam verification: To avoid this verification in future, please log in or register. 1 Answer 0 like 0 dislike answered Aug 3 by Pantycle_Genefanty (10.9k points) For this you can use ALTER USER or RENAME USER SQL statements. For changing user host easier use RENAME USER statement: RENAME USER 'tony'@'localhost' TO 'tony'@'127.0.0.1'; Your comment on this answer: Your name to display (optional): Email me at this address if a comment is added after mine:Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications. Anti-spam verification: To avoid this verification in future, please log in or register.
