in DBMS by (13.8k points)
0 like 0 dislike

How I can to change host of user in DBMS MySQL?

mysql alter user host
how to change user host in mysql

1 Answer

0 like 0 dislike
by (13.8k 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'@'';

Your answer

Try to answer the question as detailed as possible.
Your name to display (optional):
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.