Good MySQL host?

Kale · Post by **Kale** » Sun Jan 25, 2009 5:06 pm

I'm currently looking for a good MySQL host to host a site i've built but i have a few requirements:

Must allow multiple databases.
Must allow stored procedures/functions.
Must have PHP v5+ installed.

Any one using a host at the minute with these features or able to suggest one?

thanks.

the.weavster · Post by **the.weavster** » Sun Jan 25, 2009 6:26 pm

I've used 4U for several years now and I've found their service really good and they're reasonably priced too. They do offer PHP & MySQL databases but I don't know about stored procedures - you'd have to enquire about that.

http://www.4uhosting.co.uk/included.php

sphinx · Post by **sphinx** » Sun Jan 25, 2009 8:14 pm

- sorry double post -

sphinx · Post by **sphinx** » Sun Jan 25, 2009 8:15 pm

http://www.lunarpages.com/

pdwyer · Post by **pdwyer** » Mon Jan 26, 2009 3:48 am

Kale,

Not sure if I would jump up and down and say they are great, but I have a domain name through yahoo smallbusiness plan which has PHP, perl and mysql support. I haven't had time to bother using these so I don't know about the version off the top of my head or stored procs but if you can't find anything else you could try there.

I could test something for you I guess too since I don't really use my site for much

Mistrel · Post by **Mistrel** » Mon Jan 26, 2009 3:56 am

I use GoDaddy because they're cheap and support MySQL/PHP. Their PHP support stinks because they disable some important commands and won't install PEAR modules for you. But you can get around the problems by installing the modules manually and overriding php.ini within your domain.

Did I mention that they're cheap?

It's also nice to have domains, e-mail, hosting, and ssl all in one bill.

I tried DreamHost before this and the service was completely oversubscribed and unusable. I was offered a refund as compensation so I took it and left.

Kale · Post by **Kale** » Mon Jan 26, 2009 6:59 pm

I notice some hosts offer SSH access to the server. I assume this is so you can run command line utilities on the remote server from a SSH client? If this is so do you reckon i could run the mysql command line utility on the server that these hosts provide? If so this would be enough.

Most host only offer phpmyadmin as a way to admin the databases which is not very good for working with stored procedures/functions.

Mistrel · Post by **Mistrel** » Mon Jan 26, 2009 8:27 pm

Kale wrote:Most host only offer phpmyadmin as a way to admin the databases which is not very good for working with stored procedures/functions.

If it's web-based then upload your preferred solution.

pdwyer · Post by **pdwyer** » Tue Jan 27, 2009 3:34 am

SSH might only be for secure file transfer to the server. (SFTP) depends on the service I guess. putty has a psftp client if you need one