MySQL

[Aaron12344]

I have just left a Hosting server. I am wanting to homehost a server till i find another hosting an i can afford it

I am wondering how to connect the MYSQL to the Home-Hosted things

How to connect a MYSQL to a Home-Hosted MTA server?

Like the details

THANKS

[tosfera]

Oke, before you can use MySQL you should install and configure the mysql service. If you don't want a big ass download you can go for Wampp ( which I prefer ) or for Xampp. They both have a MySQL service running in the background, no need to setup a website or hwatever. They are used for it, but you can also just use the mysql service from them.

Please note that the mysql service from wamp and xampp has no default password, you should add a password to it in their files or accounts. To access your mysql you're going to use phpMyAdmin which you can find on; localhost/phpmyadmin ( once you installed one of the 2 ).

The mysql connection string would be;

local db = mysql_connect("localhost", "root", ""); 

Goodluck with this, alot of servers are using a small service like wamp or xampp to test their server. But I wouldn't prefer to host your database on the same server as your mta server. If they get access to one you'll lose them both. If they only get access somehow to your mysql server, its not a big pain. You can just put a back-up back and you're ready to go. Although you have to open the mysql's accepted connections to external connections. Which is kinda dangerous...

Also, if you have problems installing / running the apache service ( which is used for website's, but you also have to got it running ( not sure anymore ) to access the phpmyadmin address ). Turn off your skype and try it again. If you want to turn your skype or teamviewer or such off. Go to the conf.ini in the apache folder and change the listing 80 to 8080, 81, 92, or whatever. This will be the new port. You have to add this port at then end of your address:

localhost:8080/phpmyadmin/