in DBMS by (12.3k points)
0 like 0 dislike
25 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 (12.3k 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.