How to host MySQL database in my computer for a website that is hosted in a shared hosting server

Question

So I want to do this, host my database in my computer and use it for a website that I have in another server.

I want to do this because the shared hosting limits my database connections to 25 and sometimes I get "exceeded connections" errors. I think I have enough resources to do this.

I've tried modifying my mysql .cnf, opening ports, etc, but I can't get it to work.

I'm going to host with wamp or xampp.

Any link/tutorial/advice would be appreciated.

Answer 1

Advice: Don't. Just don't. The latency between your shared hosting provider and your local machine will degrade performance, and any connectivity or reliability problems at your local machine will cause your website to go down. If you've got good enough reliability to be able to handle the database, you should just host the whole site locally and be done with it.

Answer 2

Have you restarted the database ? ( restarted mysql server)

Debian/Ubuntu : /etc/init.d/mysql restart

if not some nice tutorials :

Debian/ubuntu : http://www.howtoforge.com/ubuntu_debian_lamp_server

Windows : http://www.1stwebdesigner.com/tutorials/how-to-setup-local-web-server-with-latest-apache-php-and-mysql-packages/

If you can't get it to work, try dissabling your firewall completely if you are connecting on localhost, see if it works. If it doesn't you can rule out that problem.

When connecting use localhost and not your external ip.

Also read this : http://support.tigertech.net/mysql

Also if you want easy access to your database try phpmyadmin.