How to specify mySQL host when creating the database locally?

Question

When connecting to a mysqldatabase, oftentimes you'll use --host=somehost. When creating a database locally using mySQL's Windows installer, how do you specify that? Is it possible?

I want to clarify that I want to be able to customize it - so, for instance, I want it to be something like "CUSTOMNAME-HOST" and not just "localhost"

Thanks.

Code L�?�ver · Accepted Answer · 2012-04-16 05:54:53Z

2

This is possible by changing hosts file from your operating system.

If you are using windows operating system then Open your OS installation Directory then:Windows>System32>drivers>etc

Then open your hosts file and change it to 127.0.0.1 localhost to

127.0.0.1        CUSTOMNAME-HOST

Save it.

edited Apr 16, 2012 at 5:54

Code L�?�ver

15.6k16 gold badges59 silver badges75 bronze badges

answered Apr 15, 2012 at 13:23

PHPbug

361 bronze badge

Add a comment |

Collectives™ on Stack Overflow

How to specify mySQL host when creating the database locally?

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related