Can I set my database hostname as ‘localhost’?

No, you would need to set the database hostname as the server that it's on at NYs Hosts.

You can find this by going to the MySQL Databases icon within a package. The hostname you’ll need to use will be something similiar to ‘shareddb1b.hosting.stackcp.net’ although it's likely the database name on your package will be different.

'localhost' generally means the MySQL databases are hosted on the same server as the websites, which is quite common in the web hosting industry with hosts that have a 'single-server' approach where all services run from the same machine.

It's different at NYs Hosts as we split all services and have a strict 'one server, one rule' policy. 

At the NYs Hosts data centres, web traffic, MySQL traffic and storage are all physically different machines, so 'localhost' doesn't work.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What’s the cost of a Microsoft SQL database?

For Microsoft SQL databases, there is a £9.99 monthly charge for a 1GB database.  This covers...

What is MS-SQL?

Microsoft SQL Server is a relational database management system (RDMS) developed by Microsoft. As...

How do I import a .sql file via the command-line?

If you've set up SSH access for a package then you can run the following command-line...

How do I import a .sql file via the command-line?

If you've set up SSH access for a package then you can run the following command-line...

What’s the maximum MySQL database size allowed?

Each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise only...

Powered by WHMCompleteSolution