Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I know that changing the Windows hostname on an existing MS SQL server can cause problems if you don't update certain things within MS SQL. Are there any similar issues with changing the Windows hostname for an existing MySQL installation?

share|improve this question
2  
Hmm, good question. Don't know, honestly, but I'd want to make sure the hostname is updated in the users table where applicable. –  gravyface Feb 4 '11 at 21:46

1 Answer 1

up vote 1 down vote accepted

It should work without a problem. Few years ago, there were some problems with logs and replication, but those were fixed I think and even then you could easily fix that by a few parameters (pointing to the logs).

Make sure you stop your MySQL Server before the change.

Client applications are where most of the problems are... Also watch out for database links.

Also, no one can know about your specific data that may or may not use hostname, but that is something you should already know about.
Check your data where user functions are used (hostname might be parsed out to data).

share|improve this answer
    
Thank you! <4 more characters> –  romandas Feb 11 '11 at 14:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.