in DBMS by (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

1 Answer

0 like 0 dislike
by (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 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.